Re: Checkpoint Tuning Question - Mailing list pgsql-general

From Simon Riggs
Subject Re: Checkpoint Tuning Question
Date
Msg-id 1247218483.11347.563.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Checkpoint Tuning Question  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Checkpoint Tuning Question
List pgsql-general
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


pgsql-general by date:

Previous
From: Stuart Bishop
Date:
Subject: Re: ubuntu packages for 8.4
Next
From: Tim Uckun
Date:
Subject: Re: ubuntu packages for 8.4