Re: autovacuum running even when not set in config?

Douglas Birdzell wrote:
> Hello,
>
> Recently we noticed this autovacuum process running on one of our db
> servers, which is running pg 8.2.3.
>
> 2273 ?        Ds     0:00 postgres: autovacuum process fy2006outcomesdb4091
>
> Autovacuum is off in this machine's config.  I verified that by
> connecting via psql and running 'show autovacuum'.  Also,
> pg_autovacuum on this machine has no rows.

It is normal if the database is in danger of Xid wraparound.  (So now
you know have been neglecting to vacuum some tables).

--
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"The important things in the world are problems with society that we don't
understand at all. The machines will become more complicated but they won't
be more complicated than the societies that run them."    (Freeman Dyson)