From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Ron Mayer <rm_pg@cheapcomplexdevices.com>
Cc: Scott Carey <scott@richrelevance.com>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: Henrik <henke@mac.se>
Cc: pgsql-performance@postgresql.org
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
Date: Wed, 13 Aug 2008 06:24:29 -0700
Message-ID: <48A2E08D.6000103@cheapcomplexdevices.com> (raw)
In-Reply-To: <dcc563d10808130003j37c71237q44e15859aedf391a@mail.gmail.com>
References: <32A7A76B-16CA-4CDB-AD43-973AD6A3FC7B@mac.se>
<Pine.GSO.4.64.0808081835320.21924@westnet.com>
<48A2050D.4050803@cheapcomplexdevices.com>
<a1ec7d000808121723m19b33fdk281a09434ecd5309@mail.gmail.com>
<dcc563d10808121748o79a6f667tdec70c96a06b81f9@mail.gmail.com>
<48A262F0.9080203@cheapcomplexdevices.com>
<dcc563d10808130003j37c71237q44e15859aedf391a@mail.gmail.com>
Scott Marlowe wrote:
> On Tue, Aug 12, 2008 at 10:28 PM, Ron Mayer ...wrote:
>> Scott Marlowe wrote:
>>> I can attest to the 2.4 kernel ...
>> ...SCSI...AFAICT the write barrier support...
>
> 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.
Interesting. With a pre-write-barrier 2.4 kernel I'd
expect corruption in both.
Perhaps all caches were disabled in the SCSI drives?
> I find it hard to believe there was no difference in write barrier
> behaviour with those two setups.
Skimming lkml it seems write barriers for SCSI were
behind (in terms of implementation) those for ATA
http://lkml.org/lkml/2005/1/27/94
"Jan 2005 ... scsi/sata write barrier support ...
For the longest time, only the old PATA drivers
supported barrier writes with journalled file systems.
This patch adds support for the same type of cache
flushing barriers that PATA uses for SCSI"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rm_pg@cheapcomplexdevices.com, scott.marlowe@gmail.com, scott@richrelevance.com, gsmith@gregsmith.com, henke@mac.se
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
In-Reply-To: <48A2E08D.6000103@cheapcomplexdevices.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox