Re: SSD, Postgres and safe write cache - Mailing list pgsql-performance

From Yeb Havinga
Subject Re: SSD, Postgres and safe write cache
Date
Msg-id 4FE88C38.1010604@gmail.com
Whole thread Raw
In response to SSD, Postgres and safe write cache  (Michal Szymanski <mich20061@gmail.com>)
List pgsql-performance
On 2012-06-20 16:51, Michal Szymanski wrote:
> Hi,
> We started to think about using SSD drive for our telco system DB. Because we have many "almost" read-only data I
think SSD is good candidate for our task. We would like to speed up process of read operation. 
> I've read post (http://blog.2ndquadrant.com/intel_ssd_now_off_the_sherr_sh/) about SSD which have write safe
functionalityand two drive are recommended Intel 320 and Vertex2 Pro. Both drive are rather inexpensive but both using
oldSATA II. 
> I tried to find newer faster version of Vertex because production Vertex 2 Pro is stopped but there is no information
aboutnew drives that has similar functionality and are cheap. Do you recommend cheap SSD drives that are suitable for
DBneeds? 
We were able to get OCZ Deneva 2's
(http://www.oczenterprise.com/downloads/solutions/ocz-deneva2-r-mlc-2.5in_Product_Brief.pdf)
from our supplier, which were suggested by OCZ as replacement for the
vertex 2 pro's. They're marketed as safe under power failure and our
tests with the diskchecker tool confirmed that.

regards,
Yeb Havinga


pgsql-performance by date:

Previous
From: Vitalii Tymchyshyn
Date:
Subject: Re: Postgres delete performance problem
Next
From: Craig James
Date:
Subject: MemSQL the "world's fastest database"?