From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | cluster <skrald(at)amossen(dot)dk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: B-tree fan-out |
Date: | 2007-06-23 16:34:03 |
Message-ID: | 20070623163403.GE11248@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Jun 23, 2007 at 05:58:51PM +0200, cluster wrote:
> >In any case, I think the answer to your original question is that the
> >fan-out can be up to several hundred per level, but it's not fixed.
>
> OK, its beginning to make sense. So the fan-out is given by the key size
> and each child node is stored in its own page. Is that correct?
I beleive so, yes. Each branch is a page that points to many either
branches or leaves. A leaf is also a page which can contain many keys,
which reference tuples in the actual table.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2007-06-23 16:35:36 | Re: minimum function |
Previous Message | Gunther Mayer | 2007-06-23 16:17:03 | minimum function |