Re: Load distributed checkpoint V3 - Mailing list pgsql-patches

From Heikki Linnakangas
Subject Re: Load distributed checkpoint V3
Date
Msg-id 46155070.7000406@enterprisedb.com
Whole thread Raw
In response to Re: Load distributed checkpoint V3  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Fix mdsync never-ending loop problem
Next
From: Alvaro Herrera
Date:
Subject: Re: autovacuum multiworkers, patch 5