Re: 8.1.8 autovacuum missing databases

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: 8.1.8 autovacuum missing databases
Дата
Msg-id 20080429203335.GK5652@alvh.no-ip.org
обсуждение исходный текст
Ответ на 8.1.8 autovacuum missing databases  (Ian Westmacott <ianw@intellivid.com>)
Ответы Re: 8.1.8 autovacuum missing databases  (Ian Westmacott <ianw@intellivid.com>)
Список 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 по дате отправления:

Предыдущее
От: Ian Westmacott
Дата:
Сообщение: 8.1.8 autovacuum missing databases
Следующее
От: Robert Lor
Дата:
Сообщение: Re: Remove Postgres from Solaris 10