Skip site navigation (1) Skip section navigation (2)

Re: Extreme bloating of intarray GiST indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: postgres hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Extreme bloating of intarray GiST indexes
Date: 2011-04-28 20:58:05
Message-ID: 16186.1304024285@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: David E. WheelerDate: 2011-04-28 21:16:11
Subject: Re: Extension Packaging
Previous:From: Josh BerkusDate: 2011-04-28 20:54:05
Subject: Re: Extreme bloating of intarray GiST indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group