Re: Filesystem benchmarking for pg 8.3.3 server - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Filesystem benchmarking for pg 8.3.3 server
Date
Msg-id dcc563d10808130003j37c71237q44e15859aedf391a@mail.gmail.com
Whole thread Raw
In response to Re: Filesystem benchmarking for pg 8.3.3 server  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Responses Re: Filesystem benchmarking for pg 8.3.3 server  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-performance
On Tue, Aug 12, 2008 at 10:28 PM, Ron Mayer
<rm_pg@cheapcomplexdevices.com> wrote:
> Scott Marlowe wrote:
>>
>> I can attest to the 2.4 kernel not being able to guarantee fsync on
>> IDE drives.
>
> Sure.  But note that it won't for SCSI either; since AFAICT the write
> barrier support was implemented at the same time for both.

Tested both by pulling the power plug.  The SCSI was pulled 10 times
while running 600 or so concurrent pgbench threads, and so was the
IDE.  The SCSI came up clean every single time, the IDE came up
corrupted every single time.

I find it hard to believe there was no difference in write barrier
behaviour with those two setups.

pgsql-performance by date:

Previous
From: "Sabin Coanda"
Date:
Subject: Re: long transaction
Next
From: Matthew Wakeling
Date:
Subject: Re: Filesystem benchmarking for pg 8.3.3 server