Re: Load distributed checkpoint V3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Load distributed checkpoint V3
Date: 2007-04-05 16:25:49
Message-ID: 28352.1175790349@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Heikki Linnakangas <heikki(at)enterprisedb(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-04-05 16:27:07 Re: Fix mdsync never-ending loop problem
Previous Message Tom Lane 2007-04-05 16:19:25 Re: Fix mdsync never-ending loop problem

Browse pgsql-patches by date

  From Date Subject
Next Message Heikki Linnakangas 2007-04-05 16:27:07 Re: Fix mdsync never-ending loop problem
Previous Message Tom Lane 2007-04-05 16:19:25 Re: Fix mdsync never-ending loop problem