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

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: WARNING: some databases have not been vacuumed in 1953945422 transactions
Дата
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB2013F2A1F@EXADV1.host.magwien.gv.at
обсуждение исходный текст
Ответ на WARNING: some databases have not been vacuumed in 1953945422 transactions  ("MG" <pgsql-general@carladata.de>)
Список pgsql-general
> But I don't understand why there are changes of the databases
> template1 and
> template0 at all?
> I thought they are only templates.

I don't think that there were any changes to the template databases.

You detected a difference in age(datfrozenxid) - try selecting
datfrozenxid
itself and you will probably see that it does not change over time.

Yours,
Laurenz Albe

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

Предыдущее
От: Chris
Дата:
Сообщение: Re: delete from ... where not in
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Why *exactly* is date_trunc() not immutable ?