Re: 8.2.3 AutoVacuum not running

It says it's on and I have also turned on all stats collecting.

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
Sent: Monday, April 09, 2007 3:06 PM
To: Schwenker, Stephen
Cc: Tom Lane; pgsql-general(at)postgresql(dot)org
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