From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Testing Sandforce SSD |
Date: | 2010-08-03 17:04:46 |
Message-ID: | 87k4o71vbl.fsf@cbbrowne.afilias-int.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
jd(at)commandprompt(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Rodrigo E. De León Plicet | 2010-08-04 03:29:57 | Re: Execution Plan |
Previous Message | Chris Browne | 2010-08-03 16:58:30 | Re: Testing Sandforce SSD |