Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3A9FD64FCDA for ; Thu, 4 Dec 2008 06:37:48 -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 08620-04 for ; Thu, 4 Dec 2008 06:37:45 -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 A586B64FCC4 for ; Thu, 4 Dec 2008 06:37:45 -0400 (AST) Received: from [10.31.9.119] [220.225.40.2] by mail.synechron.com with ESMTP (SMTPD-9.23) id A2F70654; Thu, 04 Dec 2008 05:37:43 -0500 Message-ID: <4937098C.4060605@synechron.com> Date: Thu, 04 Dec 2008 04:04:52 +0530 From: AmitKumar Jain User-Agent: Thunderbird 2.0.0.18 (X11/20081105) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: autovacuum benchmarking ... 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: 200812/23 X-Sequence-Number: 30856 Hi Team 1. Can we know the how much time will take ongoing vacuum process in DB? 2. Any benchmarking tool for vacuum process. 3. Can we know what exact operations has been done by Vacuum process. 4. I studied that only VACUUM process doesnot lock the table but due to it insertion in table gets very slow. when i killed vacuum daemon insertion get faster is it bug in 8.3.3 I know I should not ask all these questions in one go but i need urgently its answer as vacuum process is just screwing my production database. I would thankful for any suggestion on above question... Thanks in advance. Regards Amit