Re: BUG #2239: "vacuumdb -a" remove freeze

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #2239: "vacuumdb -a" remove freeze
Дата
Msg-id 6936.1139324981@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #2239: "vacuumdb -a" remove freeze  (Olleg Samoylov <olleg@mipt.ru>)
Список pgsql-bugs
Olleg Samoylov <olleg@mipt.ru> writes:
> IMHO "vacuumdb -a" must don't vacuum database with
> datvacuumxid=datfrozenxid.

That's not going to work because it will fail to detect whether the
database has been modified since the VACUUM FREEZE command.

In any case, what's the point?  As long as you have a routine vacuuming
process in place, it doesn't really matter whether template1 gets
scanned.  The only reason VACUUM FREEZE exists at all is to make it
possible to have a non-connectable, non-vacuumable template0.

            regards, tom lane

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

Предыдущее
От: "KF Tai"
Дата:
Сообщение: BUG #2244: silent installation to set password never expires
Следующее
От: Alfranio Correia Junior
Дата:
Сообщение: vacuum segmentation fault