| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Douglas Birdzell <dbirdzell(at)aod(dot)cx> |
| Cc: | pgsql-admin(at)postgresql(dot)org, Stephen Bacon <sbacon(at)aod(dot)cx>, Mike Russell <mrussell(at)aod(dot)cx> |
| Subject: | Re: autovacuum running even when not set in config? |
| Date: | 2007-12-10 18:48:45 |
| Message-ID: | 20071210184845.GC27126@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Koczan | 2007-12-10 19:12:34 | Legacy foreign keys |
| Previous Message | Douglas Birdzell | 2007-12-10 18:35:51 | autovacuum running even when not set in config? |