Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 97F819FB993 for ; Tue, 13 Feb 2007 12:28:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 27849-02 for ; Tue, 13 Feb 2007 12:27:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 635F29FB966 for ; Tue, 13 Feb 2007 12:27:53 -0400 (AST) Received: from perhan.alvh.no-ip.org (216-155-79-222.bk1-dsl.surnet.cl [216.155.79.222]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l1DGRqA0014538; Tue, 13 Feb 2007 08:27:53 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id E20D232A1B; Tue, 13 Feb 2007 13:27:49 -0300 (CLST) Date: Tue, 13 Feb 2007 13:27:49 -0300 From: Alvaro Herrera To: Michael Goldner Cc: pgsql-admin@postgresql.org Subject: Re: Is it normal for Autovacuum running continuously? Message-ID: <20070213162749.GC11987@alvh.no-ip.org> Mail-Followup-To: Michael Goldner , pgsql-admin@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 13 Feb 2007 08:27:53 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.099 tagged_above=0 required=5 tests=AWL, BAYES_40, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/177 X-Sequence-Number: 24642 Michael Goldner wrote: > I notice in my postgres logfile that autovacuum is running every minute. > The server had no overnight activity, yet this has been going on for days. > Overall performance of the database seems to be slow, and I assume that it > is related. It is normal. I doubt your performance problem is related to autovacuum. When you say "overall performance seems to be slow", it means you haven't actually measured individual queries and found that they are actually slow, no? > I'm running 8.1.4 on Redhat EL4.3. > > Is this normal for autovacuum? Yes. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support