Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id CB102632260 for ; Thu, 27 May 2010 13:10:37 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 50866-04 for ; Thu, 27 May 2010 16:10:27 +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 CD99463222E for ; Thu, 27 May 2010 13:10:27 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 32256348034; Thu, 27 May 2010 09:10:26 -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 x5PDtJVAkcKA; Thu, 27 May 2010 09:10:22 -0700 (PDT) Received: from perhan.alvh.no-ip.org (200-85-199-78.bk3-dsl.surnet.cl [200.85.199.78]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 8084F348002; Thu, 27 May 2010 09:10:22 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 910366E8A5; Thu, 27 May 2010 12:10:20 -0400 (CLT) Content-Type: text/plain; charset=UTF-8 Cc: pgsql-performance Subject: Re: Autovacuum in postgres. From: alvherre To: venu madhav In-reply-to: References: Date: Thu, 27 May 2010 12:10:20 -0400 Message-Id: <1274976439-sup-7339@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=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201005/234 X-Sequence-Number: 38818 Excerpts from venu madhav's message of vie may 21 05:38:43 -0400 2010: > Hi All, > In my application we are using postgres which runs on an embedded > box. I have configured autovacuum to run once for every one hour. It has 5 > different databases in it. When I saw the log messages, I found that it is > running autovacuum on one database every hour. As a result, on my database > autovacuum is run once in 5 hours. Is there any way to make it run it every > hour. If you set naptime to 12 mins, it will run on one database every 12 minutes, so once per hour for your database. This is not really the intended usage though. You will have to adjust the time if another database is created. -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support