Re: Extreme bloating of intarray GiST indexes

On 5/4/11 11:29 AM, Tom Lane wrote:
> which is up in the same ballpark with your problem.  Now probably your
> client's app is not updating all rows at once, but still this is a
> pretty wasteful update pattern.  Is there a reason not to update all
> the columns in a single update?

Yeah, really crappy application code.  Discussing it with app developers
now ...

> 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.

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