Solid state drives

[Richard Huxton]

On 19/04/10 16:00, Chris Jack wrote:
>
> Because it's been discussed previously on this list, I thought I
> might draw your attention to the newish generation of SSDs:

>  I'm not qualified to say
> if they are reliable enough for production databases - but I would be
> interested in opinions.

You might find it useful to rummage through the PostgreSQL mailing-list 
archives.

http://www.postgresql.org/community/lists/

The general opinion there is that the affordable systems are all a bit 
vague on the subject of write-caching and what they guarantee in the 
event of a power outage.

Having said that, there are clearly plenty of applications where 
power-failure isn't an overriding worry. Index tablespace is an obvious 
usage, as is temporary table/sort storage.

--
   Richard Huxton