On Mon, May 20, 2013 at 3:57 PM, Tomas Vondra <tv@xxxxxxxx> wrote: > But yes, I do agree that the provider should be ashamed for not > providing reliable SSDs in the first place. Getting reliable SSDs should > be the first option - all these suggestions are really just workarounds > of this rather simple issue. Absolutely. Reliable SSD should be the first and only option. They are significantly more expensive (more than 2x) but are worth it. When it comes to databases, particularly in the open source postgres world, hard drives are completely obsolete. SSD are a couple of orders of magnitude faster and this (while still slow in computer terms) is fast enough to put storage into the modern area by anyone who is smart enough to connect a sata cable. While everyone likes to obsess over super scalable architectures technology has finally advanced to the point where your typical SMB system can be handled by a sincle device. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
