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