| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | John W Strange <john(dot)w(dot)strange(at)jpmchase(dot)com> |
| Cc: | Benjamin Krajmalnik <kraj(at)servoyant(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Hardware recommendations |
| Date: | 2010-12-11 09:10:45 |
| Message-ID: | 4D034015.7040405@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2010-12-11 09:18:12 | Re: Hardware recommendations |
| Previous Message | Andy | 2010-12-10 19:27:28 | Re: Hardware recommendations |