Checkpoint and Background Writer Statistics

Поиск
Список
Период
Сортировка
От Sam Nelson
Тема Checkpoint and Background Writer Statistics
Дата
Msg-id AANLkTikHjPw85v0_5yGy5xNcV3=oR2kX=bXmmH0=3uO-@mail.gmail.com
обсуждение исходный текст
Ответы Re: Checkpoint and Background Writer Statistics  (Sam Nelson <samn@consistentstate.com>)
Re: Checkpoint and Background Writer Statistics  (Greg Smith <greg@2ndquadrant.com>)
Список pgsql-admin
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
www.consistentstate.com
303-955-0509
===========================

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

Предыдущее
От: Paweł Kopka
Дата:
Сообщение: ssl connection problem
Следующее
От: Sam Nelson
Дата:
Сообщение: Re: Checkpoint and Background Writer Statistics