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

From Peter Geoghegan
Subject Re: Clock sweep not caching enough B-Tree leaf pages?
Date
Msg-id CAM3SWZQstGL+Njvg00Y3gLKTHz+aNZAikoyxN734hcm9PwirCw@mail.gmail.com
Whole thread Raw
In response to Re: Clock sweep not caching enough B-Tree leaf pages?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Clock sweep not caching enough B-Tree leaf pages?
List pgsql-hackers
On Wed, Apr 16, 2014 at 7:29 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> 2. Improving the choice of which buffers we evict, which is what
> Peter's talking about, or at least what I think he's talking about.
>
> Those things are both important, but they're different, and I'm not
> sure that working on one precludes working on the other.  There's
> certainly the potential for overlap, but not necessarily.

That's certainly my primary area of interest here, but there may be
some overlap with other areas, or areas were cooperation turns out to
be appropriate. At the risk of stating the very obvious, if the
caching algorithm is making poor decisions about caching, and leaf
pages are continually swapped in and out of shared_buffers for no good
reason, that is likely to constrain the scalability of the buffer
manager. That could be very significant.

My immediate concern here is getting recognition of the importance of
weighing frequency of access in *some* way.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: assertion failure 9.3.4
Next
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: Include planning time in EXPLAIN ANALYZE output.