Re: 8.1.8 autovacuum missing databases - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: 8.1.8 autovacuum missing databases
Date
Msg-id 20080429203335.GK5652@alvh.no-ip.org
Whole thread Raw
In response to 8.1.8 autovacuum missing databases  (Ian Westmacott <ianw@intellivid.com>)
Responses Re: 8.1.8 autovacuum missing databases
List pgsql-admin
Ian Westmacott wrote:
> 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?

Is autovacuum dying before being able to finish the vacuuming of
template1 or the other database?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: Ian Westmacott
Date:
Subject: 8.1.8 autovacuum missing databases
Next
From: Robert Lor
Date:
Subject: Re: Remove Postgres from Solaris 10