Postgres Pro
Downloads
Home   >   mailing lists

B-tree fan-out - Mailing list pgsql-general

From cluster
Subject B-tree fan-out
Date
Msg-id f5h6th$uot$1@news.hub.org
Whole thread Raw
Responses Re: B-tree fan-out  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
Tree view 
What is the fan-out (number of child nodes) on each B-tree node in
postgresql? Is it dependent of the size of the keys being indexed? If
so: How?

In B-trees all non-leaf nodes have a bunch of pointers to its child
nodes. What is the size of such a pointer?


Thanks

pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: Establishing a primary key
Next
From: cluster
Date:
Subject: B-tree fan-out