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 F18FB9DCDBA for ; Sun, 19 Mar 2006 10:47:36 -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 23678-09 for ; Sun, 19 Mar 2006 10:47:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by postgresql.org (Postfix) with ESMTP id BC9709DCD22 for ; Sun, 19 Mar 2006 10:47:34 -0400 (AST) Received: from [84.143.43.47] (helo=pse.dyndns.org) by mrelayeu.kundenserver.de (node=mrelayeu10) with ESMTP (Nemesis), id 0ML31I-1FKzBy2A8g-0003gp; Sun, 19 Mar 2006 15:47:38 +0100 Received: from pse1 ([192.168.0.3]) by pse.dyndns.org with esmtp (Exim 4.44) id 1FKzBx-0005gD-4M; Sun, 19 Mar 2006 15:47:37 +0100 Message-ID: <441D6F04.10302@pse-consulting.de> Date: Sun, 19 Mar 2006 15:47:32 +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> <441C4758.9000205@pse-consulting.de> <92d3a4950603190427m47f5fad6k@mail.gmail.com> In-Reply-To: <92d3a4950603190427m47f5fad6k@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.081 required=5 tests=[AWL=0.081] X-Spam-Score: 0.081 X-Spam-Level: X-Archive-Number: 200603/318 X-Sequence-Number: 17755 Antoine wrote: > On 18/03/06, Andreas Pflug wrote: > >>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. Bring up the postgresql.conf editor on that server, and watch if pgadmin complains. Regards, Andreas