Horton

Re: Extreme bloating of intarray GiST indexes

Dimitri Fontaine <dimitri@2ndquadrant.fr>

View thread
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Josh Berkus <josh@agliodbs.com>, postgres hackers <pgsql-hackers@postgresql.org>
Date: 2011-04-29T18:50:38Z
Lists: pgsql-hackers 
Tom Lane <tgl@sss.pgh.pa.us> writes:
> Uh, no, the picksplit bugs we fixed were in cube and seg --- there's
> no reason to think that updating will help this.  But 8.4's pgstattuple
> does appear to support gist indexes, so please run that and see what
> you get.

There's also gevel that I used to inspect in development GiST index, and
I found it pretty useful.  Don't know yet how it compares to pgstattuple.

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

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