Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 185DC63314D for ; Wed, 25 Aug 2010 10:46:39 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 14475-03 for ; Wed, 25 Aug 2010 13:46:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from rs73.luxsci.com (rs73.luxsci.com [64.49.254.135]) by mail.postgresql.org (Postfix) with ESMTP id 2634F63286F for ; Wed, 25 Aug 2010 10:46:32 -0300 (ADT) Received: from GNANAM (ABTS-TN-Static-186.58.165.122.airtelbroadband.in [122.165.58.186] (may be forged)) (authenticated bits=0) by rs73.luxsci.com (8.13.8/8.13.8) with ESMTP id o7PDk6sL013821; Wed, 25 Aug 2010 08:46:07 -0500 Reply-To: From: "Gnanakumar" To: Cc: References: <001e01cb4427$76669a00$6333ce00$@com> In-Reply-To: <001e01cb4427$76669a00$6333ce00$@com> Subject: Re: last_autovacuum & last_autoanalyze showing NULL Date: Wed, 25 Aug 2010 19:15:19 +0530 Organization: Zoniac Software Private Limited Message-ID: <001001cb445b$c43d8570$4cb89050$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: ActEJ3O8YUN1CjcGR1y1iam04eqnYQAM11rg Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201008/212 X-Sequence-Number: 35461 > Truncate should not affect those values. OK. > Has your Postgres instance crashed or been restarted with immediate mode since the last vacuum? This will cause the autovacuum information to be null. No, it's been up and running for almost a week. I even checked with "select pg_postmaster_start_time()". > Also, are you sure that autovacuum has processed these tables at least once? Yes, am very sure about this. As I told earlier, I keep tab on this particular table and even noticed last autovacuum and last autoanalyze every 15 minutes (using cron job I write it to a file) with timestamp before.