Re: Extreme bloating of intarray GiST indexes

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, postgres hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Extreme bloating of intarray GiST indexes
Date: 2011-04-29 18:50:38
Message-ID: m2aaf828ox.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2011-04-29 18:56:18 EXPLAIN Node Docs?
Previous Message ktm@rice.edu 2011-04-29 18:17:22 Re: Changing the continuation-line prompt in psql?