From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Aldor <aldnin@yahoo.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Cannot kill autovacuum
Date: Tue, 4 Dec 2007 20:01:17 -0300
Message-ID: <20071204230117.GC22875@alvh.no-ip.org> (raw)
In-Reply-To: <fj4aa6$22dk$1@news.hub.org>
References: <fj3c29$2m30$1@news.hub.org>
<fj4aa6$22dk$1@news.hub.org>
Aldor wrote:
> 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?
If your database is in danger of Xid wraparound, you cannot prevent
autovacuum from starting. When the autovacuum setting is off in
postgresql.conf, this is what's happening.
--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
Este mail se entrega garantizadamente 100% libre de sarcasmo.
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, aldnin@yahoo.de
Subject: Re: Cannot kill autovacuum
In-Reply-To: <20071204230117.GC22875@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