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 CAM3SWZTzwGer872c=ZPQV1r3WFpRhFM_PrCPDCs=PztECj5PWA@mail.gmail.com
Whole thread Raw
In response to Re: Clock sweep not caching enough B-Tree leaf pages?  (Peter Geoghegan <pg@heroku.com>)
Responses Re: Clock sweep not caching enough B-Tree leaf pages?  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
On Thu, Apr 17, 2014 at 1:33 PM, Peter Geoghegan <pg@heroku.com> wrote:
> I can't imagine that this is much of a problem in practice.

Although I will add that not caching highly useful inner pages for the
medium term, because that index isn't being used at all for 5 minutes
probably is very bad. Using the 4,828 buffers that it would take to
store all the inner pages (as in my large primary index example) to go
store something else is probably penny wise and pound foolish.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: assertion in 9.4 with wal_level=logical
Next
From: Steve Singer
Date:
Subject: Re: assertion in 9.4 with wal_level=logical