Re: Intel 710 pgbench write latencies - Mailing list pgsql-performance

From Yeb Havinga
Subject Re: Intel 710 pgbench write latencies
Date
Msg-id 4EB15BFE.9000309@gmail.com
Whole thread Raw
In response to Re: Intel 710 pgbench write latencies  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Intel 710 pgbench write latencies  (Magnus Hagander <magnus@hagander.net>)
List pgsql-performance
On 2011-11-02 15:06, Kevin Grittner wrote:
> Yeb Havinga<yebhavinga@gmail.com>  wrote:
>
>> I'm now contemplating not using the 710 at all. Why should I not
>> buy two 6Gbps SSDs without supercap (e.g. Intel 510 and OCZ Vertex
>> 3 Max IOPS) with a IO controller+BBU?
>
> Wouldn't the data be subject to loss between the time the IO
> controller writes to the SSD and the time it makes it from buffers
> to flash RAM?

Good question. My guess would be no, if the raid controller does
'write-throughs' on the attached disks, and the SSD's don't lie about
when they've written to RAM.

I'll put this on my to test list for the new setup.

-- Yeb


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Guide to PG's capabilities for inlining, predicate hoisting, flattening, etc?
Next
From: Magnus Hagander
Date:
Subject: Re: Intel 710 pgbench write latencies