Re: autovacuum running even when not set in config?

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: autovacuum running even when not set in config?
Дата
Msg-id
20071210184845.GC27126@alvh.no-ip.org
Ответ на
Список
Дерево обсуждения
autovacuum running even when not set in config? Douglas Birdzell <dbirdzell@aod.cx>
Re: autovacuum running even when not set in config? Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: autovacuum running even when not set in config? Aldor <aldnin@yahoo.de>
Re: autovacuum running even when not set in config? Alvaro Herrera <alvherre@commandprompt.com>
Douglas Birdzell wrote:
> Hello,
> 
> Recently we noticed this autovacuum process running on one of our db
> servers, which is running pg 8.2.3.
> 
> 2273 ?        Ds     0:00 postgres: autovacuum process fy2006outcomesdb4091
> 
> Autovacuum is off in this machine's config.  I verified that by
> connecting via psql and running 'show autovacuum'.  Also,
> pg_autovacuum on this machine has no rows.

It is normal if the database is in danger of Xid wraparound.  (So now
you know have been neglecting to vacuum some tables).

-- 
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"The important things in the world are problems with society that we don't
understand at all. The machines will become more complicated but they won't
be more complicated than the societies that run them."    (Freeman Dyson)
В списке pgsql-admin по дате отправления
От: Douglas Birdzell
Дата:
От: Peter Koczan
Дата:
Сообщение: Legacy foreign keys
FAQ