Re: postgresql random io test with 2 SSD Kingston V+100 500GB in (software) Raid1

On 04/19/2011 05:15 AM, Laurent Laborde wrote:
> 2 kingston V+100 500GB
>

Thanks for the performance report.  The V+100 is based on a Toshiba
T6UG1XBG controller, and it doesn't have any durable cache from either a
battery or capacitor.  As such, putting a database on that drive is very
risky.  You can expect the database to be corrupted during an unusual
power outage event.  See http://wiki.postgresql.org/wiki/Reliable_Writes
for more information.

At this point most people considering one of Kingston's drives for a
database would be better off getting an Intel 320 series drive, which is
around the same price but doesn't have this issue.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books