Postgres Pro
Downloads
Home   >   mailing lists

Re: Log levels for checkpoint/bgwriter monitoring - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Log levels for checkpoint/bgwriter monitoring
Date
Msg-id 1368D272-5E19-429D-BF90-E7AF424532B3@decibel.org
Whole thread Raw
In response to Re: Log levels for checkpoint/bgwriter monitoring  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Log levels for checkpoint/bgwriter monitoring
List pgsql-hackers
Tree view 
On Mar 6, 2007, at 10:11 PM, ITAGAKI Takahiro wrote:
> I have some results that if we have plenty of time for checkpoints,
> bgwriter_all_maxpages is not a so important parameter because it is
> adjusted to "shared_buffers / duration of checkpoint".
> Also, my recommended bgwriter_lru_maxpages is "average number of
> recycled buffers per cycle", that is hardly able to tune manually.

What do you mean by 'number of recycled buffers per cycle"?
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: WITH/RECURSIVE plans
Next
From: Mark Kirkwood
Date:
Subject: Re: PostgreSQL - 'SKYLINE OF' clause added!