Re: autovacuum running even when not set in config?

Поиск
Список
Период
Сортировка
От Aldor
Тема Re: autovacuum running even when not set in config?
Дата
Msg-id fk40j1$1vs5$1@news.hub.org
обсуждение исходный текст
Ответ на 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?  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-admin
Well, the database is also showing a hint when less then 9 million
transactions are available - and this hint is telling us to vacuum
the whole database.

If, vacuum the whole database, would take days (quite unsure how
many days sometimes) is it possible to find out manually which
tables originally need a vacuum or is the xid wraparound problem
database wide so we MUST vacuum the whole database?

The automatic startup of autovacuum in this cases is really good,
but we would like to manage vacuum by ourself, especially WHEN it is
running, because we have different load times on different database
servers depending on time zones and the users using it.

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

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

Предыдущее
От: "gunartha"
Дата:
Сообщение: Re: server error
Следующее
От: Pino Martínez Herbut
Дата:
Сообщение: Ayuda Postgre