Re: how to get the height of index tree?

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: sunpeng <bluevaley(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: how to get the height of index tree?
Date: 2010-11-02 15:05:01
Message-ID: m2lj5b3gwy.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John R Pierce <pierce(at)hogranch(dot)com> writes:
>> 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 ?

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Diego Schulz 2010-11-02 15:12:27 Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?
Previous Message Steve Clark 2010-11-02 14:53:18 Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?