Josh Berkus <josh(at)agliodbs(dot)com> writes:
> On 5/4/11 11:29 AM, Tom Lane wrote:
>> If you can't change the app, I'd suggest more aggressive autovacuuming
>> as the least painful fix.
> Will test that. It's not clear that vacuuming is helping at all.
Well, you realize of course that you need a REINDEX to get the index
size back down to a sane range. Autovacuum may or may not be able to
keep it from creeping back up ... but vacuum definitely won't remove
existing bloat.
regards, tom lane