Postgres Pro
Downloads
Home   >   mailing lists

Re: how to get the height of index tree? - Mailing list pgsql-general

From John R Pierce
Subject Re: how to get the height of index tree?
Date
Msg-id 4CC24B53.7060501@hogranch.com
Whole thread Raw
In response to Re: how to get the height of index tree?  (sunpeng <bluevaley@gmail.com>)
Responses Re: how to get the height of index tree?
List pgsql-general
Tree view 
On 10/22/10 11:50 AM, sunpeng wrote:
>   what's the base of log_/a/ (/n/) function ? is that base a=16? or
> something else? how to know this base ?
>
> 2010/10/22 sunpeng <bluevaley@gmail.com <mailto:bluevaley@gmail.com>>
>
>     Hi, how to get the height of R* or B tree of created index ?
>
>


it would be based on how many index values plus overhead fits in each 8K
block.   highly variable if the field being indexed is TEXT or VARCHAR
or similar.

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Solaris install - "cannot compute sizeof (off_t)" error - readline issue?
Next
From: Mike Christensen
Date:
Subject: Re: Missing uuid_generate_v1()