Re: how to get the height of index tree?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: sunpeng <bluevaley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to get the height of index tree?
Date: 2010-10-23 02:41:23
Message-ID: 4CC24B53.7060501@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)com <mailto:bluevaley(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2010-10-23 02:51:47 Re: Missing uuid_generate_v1()
Previous Message John R Pierce 2010-10-23 02:17:39 Re: Solaris install - "cannot compute sizeof (off_t)" error - readline issue?