Horton

Re: Extreme bloating of intarray GiST indexes

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: postgres hackers <pgsql-hackers@postgresql.org>
Date: 2011-04-28T20:54:05Z
Lists: pgsql-hackers 
> 1. What PG version?

8.4.4, so it has the broken picksplit.

> 2. If new enough to have contrib/pgstattuple, what does pgstattuple()
>    have to say about the index?

Will check.

> I'm suspicious that this might be bloat caused by a bad picksplit function,
> not from having a lot of dead entries in the index.  We've fixed several
> other bogus picksplit functions in contrib in the past.

Yeah, I'll test updating to 8.4.8.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com