Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6EE3E9FB8E4 for ; Wed, 14 Feb 2007 06:52:06 -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 00254-01 for ; Wed, 14 Feb 2007 06:51:57 -0400 (AST) X-Greylist: delayed 00:06:40.372842 by SQLgrey-1.7.4 Received: from spiralcomms.com (mail.spiralcomms.com [210.193.49.8]) by postgresql.org (Postfix) with SMTP id 8831B9FB883 for ; Wed, 14 Feb 2007 06:52:00 -0400 (AST) Received: (qmail 156 invoked by uid 0); 14 Feb 2007 10:45:16 -0000 Received: from host-203-92-110-42.lga.net.sg (HELO ?192.168.3.150?) (203.92.110.42) by 0 with SMTP; 14 Feb 2007 10:45:16 -0000 Message-ID: <45D2E831.9060802@spiralcomms.com> Date: Wed, 14 Feb 2007 18:45:05 +0800 From: Dapeng User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: how do i check autovacuum is running? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1 tagged_above=0 required=5 tests=BAYES_60 X-Spam-Level: * X-Archive-Number: 200702/195 X-Sequence-Number: 24660 my server FreeBSD 6.0 Postgres 8.1 i have modified the postgresql.conf enabled the following autovacuum, stats_start_collector stats_row_level as documented in the manual now i restart my server use PgAdmin (under xp) to access my server ... i still got the hint : Running pg_autovacuum recommended is there anyway to check that the autovacuum is running or not ?? regards