Re: Log levels for checkpoint/bgwriter monitoring

From: Jim Nasby <decibel(at)decibel(dot)org>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Log levels for checkpoint/bgwriter monitoring
Date: 2007-03-07 22:24:02
Message-ID: 1368D272-5E19-429D-BF90-E7AF424532B3@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2007-03-07 22:32:59 Re: PostgreSQL - 'SKYLINE OF' clause added!
Previous Message Simon Riggs 2007-03-07 22:03:16 Re: [HACKERS] WITH/RECURSIVE plans