> 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?
> 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.
PostgreSQL Experts Inc.
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2011-04-28 20:58:05|
|Subject: Re: Extreme bloating of intarray GiST indexes |
|Previous:||From: Tom Lane||Date: 2011-04-28 20:30:10|
|Subject: Re: pgsql: Fix pg_size_pretty() to avoid overflow for inputs close to INT64 |