While I have two friends who work at FusionIO, and have great confidence in their products, we like to deploy more conventional SATA SSDs at present in our servers. We have been running various versions of Intel's enterprise and data center SSDs in production for several years now and couldn't be happier with their performance. The oldest in service at present are 710 series that have been subjected to a ~500wtps PG load 7*24 for the past 28 months. They still show zero wearout indication in the SMART stats.
As others have mentioned, power-fail protection (supercap) is the thing to look for, and also some sort of concrete specification for drive write endurance unless you have made a deliberate decision to trade off endurance vs. cost in the context of your deployment.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
