Hey, I've also notice one difference between my 8.1 instance and my 8.2 instance. I run a ps and on the 8.1 instance there is a 'stats buffer process' and in the 8.2 instance there is no 'stats buffer instance' Does that give you anymore reasons as to why the autovacuum is not working? :)
________________________________ From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Fri 06/04/2007 1:21 PM To: Schwenker, Stephen Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] 8.2.3 AutoVacuum not running "Schwenker, Stephen" <[EMAIL PROTECTED]> writes: > I've just compiled an instance of Postgresql 8.2.3 on a new linux box > and have added some databases to it. I've noticed however that the > autovacuum is not running. How sure are you of that? Check pg_stat_all_tables to see if the last_autovacuum column is changing. regards, tom lane