Re: autovacuum running even when not set in config? - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: autovacuum running even when not set in config?
Date
Msg-id 20071210184845.GC27126@alvh.no-ip.org
Whole thread Raw
In response to autovacuum running even when not set in config?  (Douglas Birdzell <dbirdzell@aod.cx>)
Responses Re: autovacuum running even when not set in config?  (Aldor <aldnin@yahoo.de>)
List pgsql-admin
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)

pgsql-admin by date:

Previous
From: Douglas Birdzell
Date:
Subject: autovacuum running even when not set in config?
Next
From: "Peter Koczan"
Date:
Subject: Legacy foreign keys