Re: Log levels for checkpoint/bgwriter monitoring

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Log levels for checkpoint/bgwriter monitoring
Дата
Msg-id 1368D272-5E19-429D-BF90-E7AF424532B3@decibel.org
обсуждение исходный текст
Ответ на Re: Log levels for checkpoint/bgwriter monitoring  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Ответы Re: Log levels for checkpoint/bgwriter monitoring  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Список 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@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)




В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: WITH/RECURSIVE plans
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: PostgreSQL - 'SKYLINE OF' clause added!