pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: John W Strange <john.w.strange@jpmchase.com>
Cc: Benjamin Krajmalnik <kraj@servoyant.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Hardware recommendations
Date: Sat, 11 Dec 2010 04:10:45 -0500
Message-ID: <4D034015.7040405@2ndquadrant.com> (raw)
In-Reply-To: <EF37296944B47C40ADDCCB7BFD6289FE046CA947A9@EMASC201VS01.exchad.jpmchase.net>
References: <F4E6A2751A2823418A21D4A160B689887B0A4C@fletch.stackdump.local>
	<F4E6A2751A2823418A21D4A160B689887B0A4D@fletch.stackdump.local>
	<EF37296944B47C40ADDCCB7BFD6289FE046CA947A9@EMASC201VS01.exchad.jpmchase.net>

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@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services and Support        www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books




view thread (26+ messages)  latest in thread

Message-ID: <4D034015.7040405@2ndquadrant.com>
Permalink:  ../4D034015.7040405@2ndquadrant.com/
Also on:    postgresql.org/message-id/4D034015.7040405@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: greg@2ndquadrant.com, john.w.strange@jpmchase.com, kraj@servoyant.com
  Subject: Re: Hardware recommendations
  In-Reply-To: <4D034015.7040405@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox