Postgres Pro
Downloads
Home   >   mailing lists

Re: Extreme bloating of intarray GiST indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Extreme bloating of intarray GiST indexes
Date
Msg-id 16186.1304024285@sss.pgh.pa.us
Whole thread Raw
In response to Re: Extreme bloating of intarray GiST indexes  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Extreme bloating of intarray GiST indexes  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
Tree view 
Josh Berkus <josh@agliodbs.com> writes:
>> 1. What PG version?

> 8.4.4, so it has the broken picksplit.
> ...
> Yeah, I'll test updating to 8.4.8.

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.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Extreme bloating of intarray GiST indexes
Next
From: "David E. Wheeler"
Date:
Subject: Re: Extension Packaging