> Just to add to the conversation, there's no real advantage to putting > WAL on SSD. Indexes can benefit from them, but WAL is mosty > seqwuential throughput and for that a pair of SATA 1TB drives at > 7200RPM work just fine for most folks.
Actually, there's a strong disadvantage to putting WAL on SSD. SSD is very prone to fragmentation if you're doing a lot of deleting and replacing files. I've implemented data warehouses where the database was on SSD but WAL was still on HDD. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
