Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 31BD29FB4B4 for ; Tue, 17 Apr 2007 23:59:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 56787-09 for ; Tue, 17 Apr 2007 23:58:32 -0300 (ADT) X-Greylist: delayed 00:59:59.66849 by SQLgrey-1.7.4 Received: from vms040pub.verizon.net (vms040pub.verizon.net [206.46.252.40]) by postgresql.org (Postfix) with ESMTP id E2E0A9FB4D3 for ; Tue, 17 Apr 2007 23:58:26 -0300 (ADT) Received: from new-host.home ([71.166.59.121]) by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JGO00DPP8588PI1@vms040.mailsrvcs.net> for pgsql-admin@postgresql.org; Tue, 17 Apr 2007 20:58:21 -0500 (CDT) Date: Tue, 17 Apr 2007 21:57:53 -0400 From: Robert Treat Subject: Re: Auto vacuum In-reply-to: <12357.1176841845@sss.pgh.pa.us> To: pgsql-admin@postgresql.org Cc: Tom Lane , Carol Walter Message-id: <200704172157.54249.robert@omniti.com> Organization: OmniTI MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-15 Content-transfer-encoding: 7bit Content-disposition: inline References: <12357.1176841845@sss.pgh.pa.us> User-Agent: KMail/1.9.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/197 X-Sequence-Number: 25261 On Tuesday 17 April 2007 16:30, Tom Lane wrote: > Carol Walter writes: > > 8.2.3 is what is reported when I run psql with the -V option. > > In 8.2 you need to increase log_min_messages to see anything about > autovacuum. It reports per-database activity at DEBUG1 and per-table > activity at DEBUG2 level. Unfortunately DEBUG2 will fill your log > with a lot of other chatter as well :-(. There's work going on > right now to improve the reporting of autovac activity for 8.3. > Till then, take a look at pg_stat_all_tables, which contains information on last autovacuum and autoanalyze runs for each table. -- Robert Treat Database Architect http://www.omniti.com