Re: WARNING: some databases have not been vacuumed in 1953945422 transactions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Дата
Msg-id 25763.1171555059@sss.pgh.pa.us
обсуждение исходный текст
Ответ на WARNING: some databases have not been vacuumed in 1953945422 transactions  ("MG" <pgsql-general@carladata.de>)
Список pgsql-general
"MG" <pgsql-general@carladata.de> writes:
> Each night a shell script is being executed.

> vacuumdb --analyze -U cmduser db1
> vacuumdb --analyze -U cmduser db2

You need to hit template1 every so often, too.  You probably might
as well just do that every night; it won't take long.

> The last weeks the following warnings are given out:
> WARNING:  some databases have not been vacuumed in 1953945422 =
> transactions

> Is this critical?

Yes.

            regards, tom lane

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

Предыдущее
От: "John D. Burger"
Дата:
Сообщение: Re: Recover anything from dropped database?
Следующее
От: Erik Jones
Дата:
Сообщение: Re: Recover anything from dropped database?