Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D21F52E0090 for ; Tue, 4 Dec 2007 07:19:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 74071-08 for ; Tue, 4 Dec 2007 07:19:16 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 5285D2E0041 for ; Tue, 4 Dec 2007 07:19:20 -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 lB4BJ9Do092940 for ; Tue, 4 Dec 2007 07:19:10 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id lB4B1UXC088161 for pgsql-admin@postgresql.org; Tue, 4 Dec 2007 07:01:30 -0400 (AST) (envelope-from news) From: Aldor X-Newsgroups: pgsql.admin Subject: Cannot kill autovacuum Date: Tue, 04 Dec 2007 12:01:12 +0100 Organization: Hub.Org Networking Services Lines: 18 Message-ID: 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) To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/12 X-Sequence-Number: 27529 When I set up a database with tons of data I forgot to check in the .conf file that autovacuum was on. Now it seems that the stat collection has prepared some tasks to be done for autovacuum - from my experience I can tell that this will take weeks or even months. I disabled autovacuum in the conf file, shut down the database, restarted it but the autovacuum process is comming up again and again. If I kill the process it takes just some minutes to start again to do it's jobs it has in memory. So, my question should be quite simple - how do I shut down autovacuum finally to not do anything more on this tables - I hope the answer is also as simple, but until right now I didn't find any solution for that. I'm using 8.2.5 version.