On Wed, 2009-07-08 at 18:22 -0400, Tom Lane wrote:
> As Greg commented upthread, we seem to be getting forced to the
> conclusion that the initial buffer scan in BufferSync() is somehow
> causing this. There are a couple of things it'd be useful to try
> here:
Not sure why you're forced to that conclusion?
ISTM more likely to be a problem with checkpointing clog or subtrans.
That would block everybody and the scale of the problem is about right.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support