Re: Clock sweep not caching enough B-Tree leaf pages?

Merlin Moncure <mmoncure(at)gmail(dot)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