On Fri, Mar 30, 2012 at 10:02 AM, Andrew Dunstan <andrew@xxxxxxxxxxxx> wrote: > Not answering your question, but standard advice is not to use RAID 5 or 6, > but RAID 10 for databases. Not sure if that still hold if you're using SSDs. Yeah, for SSD the equations may change. Parity based RAID has two problems: performance due to writes having to do a read before writing in order to calculate parity and safety (especially for raid 5) since you are at greater risk of having a second drive pop while you're rebuilding your volume. In both things the SSD might significantly reduce the negative impacts: read and write performance are highly asymmetric greatly reducing or even eliminating observed cost of the 'write hole'. Also, huge sequential speeds and generally smaller device sizes mean very rapid rebuild time. Also, higher cost/gb can play in. Food for thought. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
