Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7A7562E023C for ; Mon, 10 Dec 2007 14:36:17 -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 87312-06 for ; Mon, 10 Dec 2007 14:36:10 -0400 (AST) Received: from nemesis.aod.cx (unknown [75.148.13.157]) by postgresql.org (Postfix) with ESMTP id 02CEE2E006E for ; Mon, 10 Dec 2007 14:36:11 -0400 (AST) Received: from nemesis.aod.cx (localhost.localdomain [127.0.0.1]) by nemesis.aod.cx (8.13.6/8.13.6) with ESMTP id lBAIZpmx011695 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 10 Dec 2007 13:35:52 -0500 Received: (from dbirdzell@localhost) by nemesis.aod.cx (8.13.6/8.13.6/Submit) id lBAIZpR7011694; Mon, 10 Dec 2007 13:35:51 -0500 X-Authentication-Warning: nemesis.aod.cx: dbirdzell set sender to dbirdzell@aod.cx using -f Date: Mon, 10 Dec 2007 13:35:51 -0500 From: Douglas Birdzell To: pgsql-admin@postgresql.org Cc: Stephen Bacon , Mike Russell Subject: autovacuum running even when not set in config? Message-ID: <20071210183551.GA11514@nemesis.aod.cx> Reply-To: Douglas Birdzell Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.10i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/36 X-Sequence-Number: 27553 Hello, Recently we noticed this autovacuum process running on one of our db servers, which is running pg 8.2.3. 2273 ? Ds 0:00 postgres: autovacuum process fy2006outcomesdb4091 Autovacuum is off in this machine's config. I verified that by connecting via psql and running 'show autovacuum'. Also, pg_autovacuum on this machine has no rows. Has anyone seen this sort of behavior? Is it normal for autovacuuming to start up once in a while even when the configuration does not call for autovacuuming? Thanks, Douglas Birdzell Senior Software Developer Advanced Outcomes Design http://www.aod.cx voice: 202-872-1033 fax: 202-833-9168