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.
In response to
pgsql-admin by date
|Next:||From: Robert Lor||Date: 2008-04-29 20:48:14|
|Subject: Re: Remove Postgres from Solaris 10|
|Previous:||From: Ian Westmacott||Date: 2008-04-29 20:02:53|
|Subject: 8.1.8 autovacuum missing databases|