Message-ID: <4DAD7B0D.4000105@2ndQuadrant.com>
Date: Tue, 19 Apr 2011 08:07:41 -0400
From: Greg Smith <greg@2ndQuadrant.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.16) Gecko/20110307 Icedove/3.0.11
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: postgresql random io test with 2 SSD Kingston V+100
	500GB in (software) Raid1
References: <BANLkTim0YuRG=6=SqYjutsKHJ5JSx+dg1Q@mail.gmail.com>
In-Reply-To: <BANLkTim0YuRG=6=SqYjutsKHJ5JSx+dg1Q@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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