From: Chris Browne <cbbrowne@acm.org>
Subject: Re: Testing Sandforce SSD
Date: Tue, 03 Aug 2010 13:04:46 -0400
Organization: cbbrowne Computing Inc
Lines: 38
Message-ID: <87k4o71vbl.fsf@cbbrowne.afilias-int.info>
References: <4C4A9452.9070100@gmail.com> <4C4B1F84.5030306@2ndquadrant.com>
	<4C4B4B41.7000800@2ndquadrant.com>
	<1280005769.9866.69.camel@jd-desktop.unknown.charter.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux)
Cancel-Lock: sha1:D0r5NAcYFhEWmTYYJPklNgloI8I=
To: pgsql-performance@postgresql.org

jd@commandprompt.com ("Joshua D. Drake") writes:
> On Sat, 2010-07-24 at 16:21 -0400, Greg Smith wrote:
>> Greg Smith wrote:
>> > Note that not all of the Sandforce drives include a capacitor; I hope 
>> > you got one that does!  I wasn't aware any of the SF drives with a 
>> > capacitor on them were even shipping yet, all of the ones I'd seen 
>> > were the chipset that doesn't include one still.  Haven't checked in a 
>> > few weeks though.
>> 
>> Answer my own question here:  the drive Yeb got was the brand spanking 
>> new OCZ Vertex 2 Pro, selling for $649 at Newegg for example:  
>> http://www.newegg.com/Product/Product.aspx?Item=N82E16820227535 and with 
>> the supercacitor listed right in the main production specifications 
>> there.  This is officially the first inexpensive (relatively) SSD with a 
>> battery-backed write cache built into it.  If Yeb's test results prove 
>> it works as it's supposed to under PostgreSQL, I'll be happy to finally 
>> have a moderately priced SSD I can recommend to people for database 
>> use.  And I fear I'll be out of excuses to avoid buying one as a toy for 
>> my home system.
>
> That is quite the toy. I can get 4 SATA-II with RAID Controller, with
> battery backed cache, for the same price or less :P

Sure, but it:
- Fits into a single slot
- Is quiet
- Consumes little power
- Generates little heat
- Is likely to be about as quick as the 4-drive array

It doesn't have the extra 4TB of storage, but if you're building big-ish
databases, metrics have to change anyways.

This is a pretty slick answer for the small OLTP server.
-- 
output = reverse("moc.liamg" "@" "enworbbc")
http://linuxfinances.info/info/postgresql.html
Chaotic Evil means never having to say you're sorry.