Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9F176684BE5 for ; Wed, 19 May 2010 17:51:30 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12488-05 for ; Wed, 19 May 2010 20:51:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 58B7A684BD0 for ; Wed, 19 May 2010 17:51:23 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 7F6BD348034; Wed, 19 May 2010 13:51:21 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id fLayCMl4rU8w; Wed, 19 May 2010 13:51:19 -0700 (PDT) Received: from perhan.alvh.no-ip.org (200-85-211-144.bk4-dsl.surnet.cl [200.85.211.144]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 205E0348002; Wed, 19 May 2010 13:51:19 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 2DE4B6E8DF; Wed, 19 May 2010 16:51:17 -0400 (CLT) Content-Type: text/plain; charset=UTF-8 Cc: Ian Lea , =?utf-8?q?Devrim_G=C3=9CND=C3=9CZ?= , pgsql-admin Subject: Re: Clarification Needed: When does autovacuum daemon run? From: Alvaro Herrera To: Narasimha Murthy-VRFX87 In-reply-to: <58FEF525AF1E664D9503ACDEAC926BBC03BE7D7C@ZMY16EXM66.ds.mot.com> References: <58FEF525AF1E664D9503ACDEAC926BBC03BE7D7C@ZMY16EXM66.ds.mot.com> Date: Wed, 19 May 2010 16:51:17 -0400 Message-Id: <1274302222-sup-9370@alvh.no-ip.org> User-Agent: Sup/0.11 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.024 tagged_above=-10 required=5 tests=BAYES_50=0.8, RCVD_IN_NJABL_PROXY=2.224 X-Spam-Level: *** X-Archive-Number: 201005/183 X-Sequence-Number: 34656 Excerpts from Narasimha Murthy-VRFX87's message of mar may 18 07:04:34 -0400 2010: > I need some more clarification. autovacuum_naptime takes one minute by > default. In this case, which second of each minute the autovacuum > daemon runs (provided it is enabled)? Why does it matter which second it runs? > What is the "activity rounds" mentioned in the manual?? Each worker start is a new round. --