Re: Checkpoint Tuning Question

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