John W Strange wrote:
http://www.fusionio.com/products/iodrive/ - BEST in slot currently IMHO. http://www.intel.com/design/flash/nand/extreme/index.htm?wapkw=(X25-E) - not a bad alternative.
The FusionIO drives are OK, so long as you don't mind the possibility that your system will be down for >15 minutes after any unexpected crash. They can do a pretty time consuming verification process on the next boot if you didn't shut the server down properly before mounting.
Intel's drives have been so bad about respecting OS cache flush calls that I can't recommend them for any PostgreSQL use, due to their tendency for the database to get corrupted in the same sort of post-crash situation. See http://wiki.postgresql.org/wiki/Reliable_Writes for more background. If you get one of the models that allows being setup for reliability, those are so slow that's not even worth the trouble.
-- Greg Smith 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
