Skip site navigation (1) Skip section navigation (2)

Re: Checkpoint and Background Writer Statistics

From: Sam Nelson <samn(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Checkpoint and Background Writer Statistics
Date: 2011-02-22 22:49:57
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
Err, sorry, I think I meant bgwriter_lru_maxpages, not lru_max_dirty.
Samuel Nelson
Consistent State

On Tue, Feb 22, 2011 at 3:42 PM, Sam Nelson <samn(at)consistentstate(dot)com>wrote:

> Hi, list.
> We're trying to pull a few various metrics from the postgres catalogs to
> analyze database performance, and included is buffers_checkpoint and
> buffers_clean from pg_stat_bgwriter.
> One of our clients has an lru_max_dirty setting of 1000 and a
> bgwriter_delay of 200, but we're still seeing much higher growth in the
> buffers_checkpoint than buffers_clean, with buffers_checkpoint increasing at
> about 20 times the rate that buffers_clean is.  We don't see very much
> growth in the maxwritten_clean, though - something like one every couple of
> days.
> So the questions is, why are there still so many more checkpoint buffers
> than clean buffers written?  Does the buffers_checkpoint value include more
> than we think?  If not, can we tune things further?
> ---
> ===========================
> Samuel Nelson
> Consistent State
> 303-955-0509
> ===========================

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2011-02-22 22:51:28
Subject: Re: ssl connection problem
Previous:From: Sam NelsonDate: 2011-02-22 22:42:07
Subject: Checkpoint and Background Writer Statistics

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group