Re: Extreme bloating of intarray GiST indexes

Josh Berkus <josh@agliodbs.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