Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AAA8D2E316D for ; Tue, 4 Dec 2007 15:49:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 19434-01-3 for ; Tue, 4 Dec 2007 15:49:23 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id AE8E02E316B for ; Tue, 4 Dec 2007 15:49:25 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id lB4JnBul093885 for ; Tue, 4 Dec 2007 15:49:11 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id lB4JbhLJ068073 for pgsql-admin@postgresql.org; Tue, 4 Dec 2007 15:37:43 -0400 (AST) (envelope-from news) From: Aldor X-Newsgroups: pgsql.admin Subject: Re: Cannot kill autovacuum Date: Tue, 04 Dec 2007 20:37:28 +0100 Organization: Hub.Org Networking Services Lines: 14 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) In-Reply-To: To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/16 X-Sequence-Number: 27533 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?