On Wed, Jul 15, 2009 at 6:51 AM, Wayne Conrad<wayne@xxxxxxxxxxxx> wrote: > On Tue, 14 Jul 2009, Scott Marlowe wrote: >> >> Just wondering, which pgsql version, and also, do you have >> autovacuum turned on? > > Dang, I should have said in my initial message. 8.3.6, and autovacuum > is turned on and has plenty of log activity. Are you guys doing anything that could be deemed pathological, like full table updates on big tables over and over? Had an issue last year where a dev left a where clause off an update to a field in one of our biggest tables and in a few weeks the database was so bloated we had to take it offline to fix the problem. After fixing the query. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
