Re: B-tree fan-out

From: cluster <skrald(at)amossen(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: B-tree fan-out
Date: 2007-06-23 14:11:52
Message-ID: 467D2A28.5040709@amossen.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> In postgres, everything is done in pages, so how ever many keys fit in
> a page. Bigs keys mean less. For integers you can fit an awful lot of
> keys.
>
>
OK, interesting. Does that mean, that when a node containing only small
values (e.g. integers) is split, then it gets an awful lot of child nodes?

>> In B-trees all non-leaf nodes have a bunch of pointers to its child
>> nodes. What is the size of such a pointer?
> I imagine it's a page number, probably just a 32-bit integer.
>
OK, thanks a lot. Do you know if other database systems implement
b-trees this way too? I.e. one page per node.

Thanks!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joris Dobbelsteen 2007-06-23 14:28:56 Re: Proposed Feature
Previous Message jef peeraer 2007-06-23 13:00:30 Re: permission denied for schema