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 12460.1397677222@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>)
List pgsql-hackers
Merlin Moncure <mmoncure@gmail.com> writes:
> On Wed, Apr 16, 2014 at 1:44 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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.)

> sure -- note we already track that in BufferStrategyControl
> (everything in buffer allocation is already centrally managed
> essentially).

Indeed, but I'd think getting rid of that property would be one of the
top priorities for any attempt to do anything at all in this area of
the code.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Clock sweep not caching enough B-Tree leaf pages?
Next
From: Alvaro Herrera
Date:
Subject: Re: Need Multixact Freezing Docs