Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 50D242E325B for ; Tue, 4 Dec 2007 19:12:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 76309-02 for ; Tue, 4 Dec 2007 19:12:04 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 515D22E35AD for ; Tue, 4 Dec 2007 19:01:23 -0400 (AST) Received: from perhan.alvh.no-ip.org (200-126-116-213.bk8-dsl.surnet.cl [200.126.116.213]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lB4N1I5l023898 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 4 Dec 2007 15:01:21 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 72CA547C69; Tue, 4 Dec 2007 20:01:17 -0300 (CLST) Date: Tue, 4 Dec 2007 20:01:17 -0300 From: Alvaro Herrera To: Aldor Cc: pgsql-admin@postgresql.org Subject: Re: Cannot kill autovacuum Message-ID: <20071204230117.GC22875@alvh.no-ip.org> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.16 (2007-06-11) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 04 Dec 2007 15:01:22 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/17 X-Sequence-Number: 27534 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.