Postgres Pro
Downloads
Home   >   mailing lists

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

From Dimitri Fontaine
Subject Re: how to get the height of index tree?
Date
Msg-id m2lj5b3gwy.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: how to get the height of index tree?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
John R Pierce <pierce@hogranch.com> writes:
>> 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 ?

You could use Gevel for GiST and GIN:

  http://www.sai.msu.su/~megera/wiki/Gevel

Don't know if something similar exists for btree, but I guess it would
be very useful.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-general by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: pg_get_procdef ?
Next
From: Diego Schulz
Date:
Subject: Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?