Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 310A82E004C for ; Tue, 29 Apr 2008 17:22:12 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 08004-07 for ; Tue, 29 Apr 2008 17:22:04 -0300 (ADT) X-Greylist: delayed 00:19:14.328126 by SQLgrey-1.7.5 Received: from mailhost.intellivid.com (mailhost.intellivid.com [64.32.200.11]) by developer.postgresql.org (Postfix) with ESMTP id 6FC922E004D for ; Tue, 29 Apr 2008 17:22:08 -0300 (ADT) Received: from [192.168.2.80] (vega.intellivid.com [192.168.2.80]) by newmail.intellivid.com (Postfix) with ESMTP id 1616B6C69A for ; Tue, 29 Apr 2008 16:02:55 -0400 (EDT) Subject: 8.1.8 autovacuum missing databases From: Ian Westmacott To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: IntelliVid Corp. Date: Tue, 29 Apr 2008 16:02:53 -0400 Message-Id: <1209499373.18622.47.camel@vega.intellivid.com> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/288 X-Sequence-Number: 29052 I have a Postgres 8.1.8 system with three databases. Although autovacuum is enabled (I'm using all default autovacuum configuration settings) and pg_autovacuum is empty, the logs indicate that only template1 and one of the three databases are being processed by autovacuum. Are there other reasons why the other two databases might be skipped, or some way I could diagnose the issue? Thanks, --Ian