pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Douglas Birdzell <dbirdzell@aod.cx>
Cc: pgsql-admin@postgresql.org, Stephen Bacon <sbacon@aod.cx>
Cc: Mike Russell <mrussell@aod.cx>
Subject: Re: autovacuum running even when not set in config?
Date: Mon, 10 Dec 2007 15:48:45 -0300
Message-ID: <20071210184845.GC27126@alvh.no-ip.org> (raw)
In-Reply-To: <20071210183551.GA11514@nemesis.aod.cx>
References: <20071210183551.GA11514@nemesis.aod.cx>

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)



view thread (4+ messages)  latest in thread

Message-ID: <20071210184845.GC27126@alvh.no-ip.org>
Permalink:  ../20071210184845.GC27126@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20071210184845.GC27126@alvh.no-ip.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alvherre@alvh.no-ip.org, dbirdzell@aod.cx, sbacon@aod.cx, mrussell@aod.cx
  Subject: Re: autovacuum running even when not set in config?
  In-Reply-To: <20071210184845.GC27126@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox