Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id C970664FD1F
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 13 Aug 2008 04:03:38 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 06259-09 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 13 Aug 2008 04:03:30 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.29])
	by postgresql.org (Postfix) with ESMTP id CCEFF64FD19
	for <pgsql-performance@postgresql.org>;
	Wed, 13 Aug 2008 04:03:31 -0300 (ADT)
Received: by yx-out-2324.google.com with SMTP id 8so1075470yxb.73
	for <pgsql-performance@postgresql.org>;
	Wed, 13 Aug 2008 00:03:30 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type
	:content-transfer-encoding:content-disposition:references;
	bh=EgN5ZiIty3ycz17Wi1fUKJ0tdqYieAkvq8OaQrJ/M1M=;
	b=tH0TWDhmZNkU1KZgX04rRN7cHRkN+eCji5G/kFwb/eo6J9XQ2PTUP8/EEew1slG630
	MWvckx+5z+uBAgB92Nbf1MNiuPFKFv2BM2D3MFIWT4f/C1em3PMz/KjIi9i9LG7SDNU7
	OjGnb/v/0xWF5H8F8dm4e+7Iu0ADZaJ+nS0hg=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=c+4SKp1kmwyPRsyUXmbvVGVnXJiAJizx0IlBUAnj6IlxWTxHGjK+hsCcMMn/8E4+Sg
	xUGip4mtzWjICorkXpuByA/mQb9Zdj2fJKgCEKk1G2Y3Qog8/bM4yR7L9waikSIiWry+
	I/00aqI7cj4Soek9lPB5JsSB0kidTdH21jkJo=
Received: by 10.142.172.12 with SMTP id u12mr3132944wfe.116.1218611010039;
	Wed, 13 Aug 2008 00:03:30 -0700 (PDT)
Received: by 10.142.165.13 with HTTP; Wed, 13 Aug 2008 00:03:29 -0700 (PDT)
Message-ID: <dcc563d10808130003j37c71237q44e15859aedf391a@mail.gmail.com>
Date: Wed, 13 Aug 2008 01:03:29 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Ron Mayer" <rm_pg@cheapcomplexdevices.com>
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
Cc: "Scott Carey" <scott@richrelevance.com>,
	"Greg Smith" <gsmith@gregsmith.com>,
	Henrik <henke@mac.se>, pgsql-performance@postgresql.org
In-Reply-To: <48A262F0.9080203@cheapcomplexdevices.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200808/147
X-Sequence-Number: 31028

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.