From: Aldor <aldnin@yahoo.de>
To: pgsql-admin@postgresql.org
Subject: Re: Cannot kill autovacuum
Date: Tue, 04 Dec 2007 20:37:28 +0100
Message-ID: <fj4aa6$22dk$1@news.hub.org> (raw)
In-Reply-To: <fj3c29$2m30$1@news.hub.org>
References: <fj3c29$2m30$1@news.hub.org>
Hint: When turning configuration for autovacuum to minimal settings
they are recognized by the autovacuum process started from
postmaster. The setting "autovacuum = off" - which I tried to put
also into other areas of the conf file (to avoid that it is maybe
not parsed corretly) - is not recognized. I also checked pg_settings
and autovacuum is "off" - I also tried it with "false" - no change.
The autovacuum process is always started some seconds after
postmaster is started.
I can see in the pg_stat_activity that autovacuum is doing some
VACUUM on some of this tables.
Any hint what I can try to disable autovacuum?
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: aldnin@yahoo.de
Subject: Re: Cannot kill autovacuum
In-Reply-To: <fj4aa6$22dk$1@news.hub.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