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