Postgres Pro
Downloads
Home   >   mailing lists

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 CAM3SWZSLxxvxovJvU6mf8fs4DOp7OrbMhmt0ptMCLozMSKN-Qg@mail.gmail.com
Whole thread Raw
In response to Re: Clock sweep not caching enough B-Tree leaf pages?  (Hannu Krosing <hannu@krosing.net>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Review: Patch FORCE_NULL option for copy COPY in CSV mode
Next
From: Alvaro Herrera
Date:
Subject: Re: assertion failure 9.3.4