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.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin