Re: 8.1.8 autovacuum missing databases

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 8.1.8 autovacuum missing databases
Дата
Msg-id 19778.1209572869@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 8.1.8 autovacuum missing databases  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: 8.1.8 autovacuum missing databases  (Ian Westmacott <ianw@intellivid.com>)
Список pgsql-admin
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Right -- if you have two databases over the wraparound edge, it will
> alternate between them.

> I still think that the autovac is dying before completing the task.  Did
> you investigate whether there are "ERROR" messages coming from
> autovacuum?  No PG crashes would happen.

AFAICS, if it's triggering a whole_db run and the run fails to get to
the point of updating pg_database, then the next run will pick the very
same db.

I'm noticing though that the 8.1 logic pays attention to both
datvacuumxid and datfrozenxid.  Could we see the age() of both of
those columns for all the databases?

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: 8.1.8 autovacuum missing databases
Следующее
От: Ian Westmacott
Дата:
Сообщение: Re: 8.1.8 autovacuum missing databases