Horton

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

Peter Geoghegan <pg@heroku.com>

View thread View on postgr.es
From: Peter Geoghegan <pg@heroku.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jim Nasby <jim@nasby.net>, Robert Haas <robertmhaas@gmail.com>, Andres Freund <andres@2ndquadrant.com>, Merlin Moncure <mmoncure@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2014-04-22T01:37:08Z
Lists: pgsql-hackers 
On Mon, Apr 21, 2014 at 5:59 PM, Peter Geoghegan <pg@heroku.com> wrote:
> LRU-K, and 2Q have roughly the same advantages. I'm
> reasonably confident you can have the best of both worlds, or
> something closer to it.

Having said that, a big part of what I'd like to accomplish here is to
address the more general problem of "correlated references". That's
probably something that has independent value.


-- 
Peter Geoghegan

Commits

  1. Replace the BufMgrLock with separate locks on the lookup hashtable and