Re: Load distributed checkpoint V3

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Load distributed checkpoint V3
Дата
Msg-id 46155070.7000406@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Load distributed checkpoint V3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Tom Lane wrote:
> Heikki Linnakangas <heikki@enterprisedb.com> writes:
>> The number of buffers evicted by normal backends in a bgwriter_delay
>> period is simple to keep track of, just increase a counter in
>> StrategyGetBuffer and reset it when bgwriter wakes up. We can use that
>> as an estimate of X with some safety margin.
>
> You'd want some kind of moving-average smoothing in there, probably with
> a lot shorter ramp-up than ramp-down time constant, but this seems
> reasonable enough to try.

Ironically, I just noticed that we already have a patch in the patch
queue that implements exactly that, again by Itagaki. I need to start
paying more attention :-). Keep up the good work!

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Fix mdsync never-ending loop problem
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: autovacuum multiworkers, patch 5