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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
