It says it's on and I have also turned on all stats collecting. -----Original Message----- From: Alvaro Herrera [mailto:alvherre@xxxxxxxxxxxxxxxxx] Sent: Monday, April 09, 2007 3:06 PM To: Schwenker, Stephen Cc: Tom Lane; pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] 8.2.3 AutoVacuum not running Schwenker, Stephen wrote: > 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? No -- the stats buffer process was removed in 8.2 on purpose. If you do a "show autovacuum", does it show as on? Maybe it was disabled due to misconfiguration. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
