Re: strange pgbench results (as if blocked at the end)

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: tv(at)fuzzy(dot)cz, pgsql-performance(at)postgresql(dot)org
Subject: Re: strange pgbench results (as if blocked at the end)
Date: 2011-08-15 20:36:49
Message-ID: 4E498361.6030408@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2011-08-15 23:49:52 Reports from SSD purgatory
Previous Message hyelluas 2011-08-15 18:32:34 Re: How to see memory usage using explain analyze ?