Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 17C2B1337BA4 for ; Fri, 12 Nov 2010 15:44:09 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 05654-09 for ; Fri, 12 Nov 2010 19:44:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailgate.iii.com (mailgate.iii.com [205.227.88.3]) by mail.postgresql.org (Postfix) with ESMTP id A61DA1337B81 for ; Fri, 12 Nov 2010 15:44:01 -0400 (AST) Received: from mailhub.iii.com (mailhub [10.1.2.3]) by mailgate.iii.com (8.13.6/8.13.6) with ESMTP id oACJabvF032241 for ; Fri, 12 Nov 2010 11:36:37 -0800 (PST) Received: from [10.1.7.210] ([10.1.7.210]) by mailhub.iii.com (8.13.6/8.13.6) with ESMTP id oACJkxc2016257 for ; Fri, 12 Nov 2010 11:46:59 -0800 (PST) Message-ID: <4CDD9907.2080902@iii.com> Date: Fri, 12 Nov 2010 11:44:07 -0800 From: Dinesh Bhandary Reply-To: dbhandary@iii.com Organization: Innovative Interfaces User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: auto vacuum question 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.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/107 X-Sequence-Number: 36073 Hi All - I am working to tune the auto vacuum in 8.4 and 8.2. I am finding that some of the tables are not getting vacuumed even though they exceed analyze/vacuum threshold. Do you know where auto vacuum process looks to get the number of rows deleted/updated/inserted? pg_stat_user_tables have only the cumulative stats. I am interested in finding the most current ( incremental stats). Thanks a lot. Dinesh