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: Hannu Krosing <hannu@krosing.net>
Cc: Andres Freund <andres@2ndquadrant.com>, Greg Stark <stark@mit.edu>, Ants Aasma <ants@cybertec.at>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2014-04-22T20:16:00Z
Lists: pgsql-hackers 
On Tue, Apr 22, 2014 at 2:03 AM, Hannu Krosing <hannu@krosing.net> wrote:
> What is the depth of b-tree at this percentage ?

Well, this percentage of B-Tree pages that are leaf pages doesn't have
much to do with the depth. The percentage seems very consistent for
each B-Tree, irrespective of the total size of the B-Tree.

-- 
Peter Geoghegan

Commits

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