Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4264B64FC93 for ; Thu, 27 Nov 2008 11:45:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 94018-04 for ; Thu, 27 Nov 2008 11:45:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.synechron.com (mail.synechron.com [74.205.14.240]) by mail.postgresql.org (Postfix) with ESMTP id 559A964FD6F for ; Thu, 27 Nov 2008 11:45:11 -0400 (AST) Received: from [10.31.9.119] [220.225.40.2] by mail.synechron.com with ESMTP (SMTPD-9.23) id A08403D0; Thu, 27 Nov 2008 10:45:08 -0500 Message-ID: <492E1748.50408@synechron.com> Date: Thu, 27 Nov 2008 09:13:04 +0530 From: AmitKumar Jain User-Agent: Thunderbird 2.0.0.18 (X11/20081105) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: AutoVaccuum process start as its off in potgresql.conf] 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=4.201 tagged_above=0 required=5 tests=DATE_IN_PAST_12_24=1.77, DNS_FROM_OPENWHOIS=2.431 X-Spam-Level: **** X-Archive-Number: 200811/163 X-Sequence-Number: 30817 Hi , I am using PostgreSQL 8.3 version . The autovacuum process is stucking my system as it automtically start even though its off is postgresql.conf. 2. Is there any benchmark tool for Autovacuum process or can we know how much time this proces will take to complete? Thanks in Advance. Regards Amit