Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7C9DE2E02A0 for ; Mon, 10 Dec 2007 14:49:03 -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 73108-04-6 for ; Mon, 10 Dec 2007 14:48:56 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 2459A2E0289 for ; Mon, 10 Dec 2007 14:48:57 -0400 (AST) Received: from perhan.alvh.no-ip.org (200-126-109-160.bk7-dsl.surnet.cl [200.126.109.160]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lBAImirk019290 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 10 Dec 2007 10:48:47 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 6D6E347C81; Mon, 10 Dec 2007 15:48:45 -0300 (CLST) Date: Mon, 10 Dec 2007 15:48:45 -0300 From: Alvaro Herrera To: Douglas Birdzell Cc: pgsql-admin@postgresql.org, Stephen Bacon , Mike Russell Subject: Re: autovacuum running even when not set in config? Message-ID: <20071210184845.GC27126@alvh.no-ip.org> References: <20071210183551.GA11514@nemesis.aod.cx> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20071210183551.GA11514@nemesis.aod.cx> User-Agent: Mutt/1.5.17 (2007-11-01) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Mon, 10 Dec 2007 10:48:47 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/37 X-Sequence-Number: 27554 Douglas Birdzell wrote: > 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. It is normal if the database is in danger of Xid wraparound. (So now you know have been neglecting to vacuum some tables). -- Alvaro Herrera http://www.advogato.org/person/alvherre "The important things in the world are problems with society that we don't understand at all. The machines will become more complicated but they won't be more complicated than the societies that run them." (Freeman Dyson)