Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 46EA59FB60B for ; Tue, 17 Apr 2007 17:30:58 -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 96409-01 for ; Tue, 17 Apr 2007 17:30:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id F1F069FB78C for ; Tue, 17 Apr 2007 17:30:49 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l3HKUkf3012358; Tue, 17 Apr 2007 16:30:46 -0400 (EDT) To: Carol Walter cc: pgsql-admin@postgresql.org Subject: Re: Auto vacuum In-reply-to: References: <8229.1176840883@sss.pgh.pa.us> Comments: In-reply-to Carol Walter message dated "Tue, 17 Apr 2007 16:25:14 -0400" Date: Tue, 17 Apr 2007 16:30:45 -0400 Message-ID: <12357.1176841845@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/162 X-Sequence-Number: 25226 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. regards, tom lane