X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B92E99DCA69 for ; Sat, 18 Mar 2006 13:46:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77275-08 for ; Sat, 18 Mar 2006 13:46:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.177]) by postgresql.org (Postfix) with ESMTP id 76A0E9DC9CE for ; Sat, 18 Mar 2006 13:46:12 -0400 (AST) Received: from [84.143.28.185] (helo=pse.dyndns.org) by mrelayeu.kundenserver.de (node=mrelayeu5) with ESMTP (Nemesis), id 0ML25U-1FKfV32o5C-0007sA; Sat, 18 Mar 2006 18:46:11 +0100 Received: from pse1 ([192.168.0.3]) by pse.dyndns.org with esmtp (Exim 4.44) id 1FKfV2-0004wc-Ky; Sat, 18 Mar 2006 18:46:00 +0100 Message-ID: <441C4758.9000205@pse-consulting.de> Date: Sat, 18 Mar 2006 18:46:00 +0100 From: Andreas Pflug User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Antoine CC: pgsql-performance@postgresql.org Subject: Re: n00b autovacuum question References: <92d3a4950603180401p7deb391cp@mail.gmail.com> In-Reply-To: <92d3a4950603180401p7deb391cp@mail.gmail.com> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: kundenserver.de abuse@kundenserver.de login:0ce7ee5c3478b8d72edd8e05ccd40b70 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.08 required=5 tests=[AWL=0.080] X-Spam-Score: 0.08 X-Spam-Level: X-Archive-Number: 200603/308 X-Sequence-Number: 17745 Antoine wrote: > Hi, > I have enabled the autovacuum daemon, but occasionally still get a > message telling me I need to run vacuum when I access a table in > pgadmin. pgAdmin notices a discrepancy between real rowcount and estimated rowcount and thus suggests to run vacuum/analyze; it won't examine autovacuum rules so it might warn although autovac is running ok. If you're sure autovacuum is running fine, just dismiss the message. It's a hint for newbies that do *not* run vacuum because they don't know what it's good for. Regards Andreas