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

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Hannu Krosing <hannu(at)krosing(dot)net>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, Greg Stark <stark(at)mit(dot)edu>, Ants Aasma <ants(at)cybertec(dot)at>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Clock sweep not caching enough B-Tree leaf pages?
Date: 2014-04-22 20:16:00
Message-ID: CAM3SWZSLxxvxovJvU6mf8fs4DOp7OrbMhmt0ptMCLozMSKN-Qg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Apr 22, 2014 at 2:03 AM, Hannu Krosing <hannu(at)krosing(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2014-04-22 21:01:40 Re: assertion failure 9.3.4
Previous Message Bruce Momjian 2014-04-22 20:07:08 Re: Review: Patch FORCE_NULL option for copy COPY in CSV mode