pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Douglas Birdzell <dbirdzell@aod.cx>
To: pgsql-admin@postgresql.org
Cc: Stephen Bacon <sbacon@aod.cx>
Cc: Mike Russell <mrussell@aod.cx>
Subject: autovacuum running even when not set in config?
Date: Mon, 10 Dec 2007 13:35:51 -0500
Message-ID: <20071210183551.GA11514@nemesis.aod.cx> (raw)

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.

Has anyone seen this sort of behavior?  Is it normal for autovacuuming
to start up once in a while even when the configuration does not call
for autovacuuming?

Thanks,

Douglas Birdzell
Senior Software Developer
Advanced Outcomes Design

http://www.aod.cx
voice: 202-872-1033
fax:   202-833-9168





view thread (4+ messages)  latest in thread

Message-ID: <20071210183551.GA11514@nemesis.aod.cx>
Permalink:  ../20071210183551.GA11514@nemesis.aod.cx/
Also on:    postgresql.org/message-id/20071210183551.GA11514@nemesis.aod.cx

 · 

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: dbirdzell@aod.cx, sbacon@aod.cx, mrussell@aod.cx
  Subject: Re: autovacuum running even when not set in config?
  In-Reply-To: <20071210183551.GA11514@nemesis.aod.cx>

* 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