Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter

On 10/04/2011 03:50 AM, Venkat Balaji wrote:

I had a look at the pg_stat_bgwriter as well.

Try saving it like this instead:

select now(),* from pg_stat_bgwriter;

And collect two data points, space a day or more apart.  That gives a lot more information about the rate at which things are actually happening.  The long-term totals are less interesting than that.

Generally the first round of tuning work here is to increase checkpoint_segments until most checkpoints appear in checkpoints_timed rather than checkpoints_req.  After that, increasing checkpoint_timeout might also be useful.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance