> 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