Re: Clock sweep not caching enough B-Tree leaf pages? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Clock sweep not caching enough B-Tree leaf pages?
Date
Msg-id 11258.1397673898@sss.pgh.pa.us
Whole thread Raw
In response to Re: Clock sweep not caching enough B-Tree leaf pages?  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Clock sweep not caching enough B-Tree leaf pages?  (Merlin Moncure <mmoncure@gmail.com>)
Re: Clock sweep not caching enough B-Tree leaf pages?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Merlin Moncure <mmoncure@gmail.com> writes:
> Anyways, I'm still curious if you can post similar numbers basing the
> throttling on gross allocation counts instead of time.  Meaning: some
> number of buffer allocations has to have occurred before you consider
> eviction.  Besides being faster I think it's a better implementation:
> an intermittently loaded server will give more consistent behavior.

Yeah --- I think wall-clock-based throttling is fundamentally the wrong
thing anyway.  Are we going to start needing a CPU speed measurement to
tune the algorithm with?  Not the place to be going.  But driving it off
the number of allocations that've been done could be sensible.  (OTOH,
that means you need a central counter, which itself would be a
bottleneck.)
        regards, tom lane



pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Clock sweep not caching enough B-Tree leaf pages?
Next
From: Josh Berkus
Date:
Subject: Re: The case against multixact GUCs