From: Greg Smith <greg@2ndQuadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: tv@fuzzy.cz
Cc: pgsql-performance@postgresql.org
Subject: Re: strange pgbench results (as if blocked at the end)
Date: Mon, 15 Aug 2011 16:36:49 -0400
Message-ID: <4E498361.6030408@2ndQuadrant.com> (raw)
In-Reply-To: <28386.1313343224@sss.pgh.pa.us>
References: <2f9ba8ed6e4ed11d9a6d236cb4d2a2ec.squirrel@sq.gransy.com>
<4E45EAD3.9030102@2ndQuadrant.com>
<bdf03aa0550140de6491b3ce6d3eebd4@mail.gransy.com>
<28386.1313343224@sss.pgh.pa.us>
On 08/14/2011 01:33 PM, Tom Lane wrote:
> (The changes in question were purely for performance, and involved a
> conversion from write barriers in the block layer to flush+fua, whatever
> that is.) Furthermore, this affected every filesystem not only ext4,
> so it really entirely fails to support Greg's argument.
>
FUA is "Force Unit Access", shorthand for forcing write-through. If
you're staring at this from the perspective I am, where I assume that
every line of new filesystem code always takes a while from release
until it's stable, it still concerns me. I suspect that both of these
code paths--the write barrier one and the flush+FUA one--are fine on
XFS. One of the reasons XFS was so terrible in its early years was
because it took a long time to get those parts in particular correct,
which was complicated by how badly drives lied about everything back then.
If these changes shift around which section of the ext4 write path code
are exercised, it could easily be the case that it moves fsync related
work (which has been one of the buggiest parts of that filesystem) from
code that has been tested heavily to parts that haven't been hit as hard
yet by users. My paranoid raving about this particular bug isn't
strongly supported; I'll concede that with the additional data you've
provided. But I don't think it's completely unfounded either.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
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: greg@2ndQuadrant.com, tgl@sss.pgh.pa.us, tv@fuzzy.cz
Subject: Re: strange pgbench results (as if blocked at the end)
In-Reply-To: <4E498361.6030408@2ndQuadrant.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