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

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

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fix mdsync never-ending loop problem
Next
From: Heikki Linnakangas
Date:
Subject: Re: Fix mdsync never-ending loop problem