Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 294C42E02AB for ; Tue, 4 Dec 2007 08:19:21 -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 07593-08 for ; Tue, 4 Dec 2007 08:19:10 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id D38AC2E02A2 for ; Tue, 4 Dec 2007 08: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 lB4CJA1j008452 for ; Tue, 4 Dec 2007 08: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 lB4Bso2A001174 for pgsql-admin@postgresql.org; Tue, 4 Dec 2007 07:54:50 -0400 (AST) (envelope-from news) From: Aldor X-Newsgroups: pgsql.admin Subject: Re: Cannot kill autovacuum Date: Tue, 04 Dec 2007 12:54:33 +0100 Organization: Hub.Org Networking Services Lines: 59 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/15 X-Sequence-Number: 27532 Temporary(!) solution: insert into pg_autovacuum ( vacrelid, enabled, vac_base_thresh, vac_scale_factor, anl_base_thresh, anl_scale_factor, vac_cost_delay, vac_cost_limit, freeze_min_age, freeze_max_age ) select oid as vacrelid, false as enabled, 0, 0, 0, 0, 0, 0, 0, 0 from pg_class where relnamespace = 38048977 and relkind = 'r'; I'm not 100% sure if this is a temporary solution, because I definitly don't know the time when the autovacuum worker is going to run again, but after 3-4 minutes there is no new autovacuum worker running. It seems that autovacuum checks if the table is disabled for autovacuum but it's not checking if the configuration variable autovacuum is off?! That's really strange! Well, one more question: Is it possible to link vacrelid with a database in pg_database instead of a table? Aldor wrote: > 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.