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
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