Horton

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

Hannu Krosing <hannu@krosing.net>

View thread View on postgr.es
From: Hannu Krosing <hannu@krosing.net>
To: Andres Freund <andres@2ndquadrant.com>, Peter Geoghegan <pg@heroku.com>
Cc: Greg Stark <stark@mit.edu>, Ants Aasma <ants@cybertec.at>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2014-04-22T09:03:22Z
Lists: pgsql-hackers 
On 04/17/2014 10:39 PM, Andres Freund wrote:
> On 2014-04-17 13:33:27 -0700, Peter Geoghegan wrote:
>> Just over 99.6% of pages (leaving aside the meta page) in the big 10
>> GB pgbench_accounts_pkey index are leaf pages.

What is the depth of b-tree at this percentage ?

Cheers
Hannu

Commits

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