Re: VACUUM and transaction ID wraparound

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM and transaction ID wraparound
Дата
Msg-id 2297.1053146411@sss.pgh.pa.us
обсуждение исходный текст
Ответ на VACUUM and transaction ID wraparound  ("Dean Gibson (DB Administrator)" <dba-sql@ultimeth.net>)
Список pgsql-general
"Dean Gibson (DB Administrator)" <dba-sql@ultimeth.net> writes:
> The documentation says (Admin Guide, 8.2.3), "... each database-wide
> VACUUM automatically delivers a warning" if individual tables need
> VACUUMing to prevent transaction ID wraparound.

Not individual tables, but whole databases (databases other than the one
you just vacuumed, obviously).

> Is there something here I don't understand?

The warning is intended to alert you in case you have entire databases
you've forgotten to vacuum for a good long while.  It's a compromise
between being too much in-your-face and letting you go down to
disaster...

            regards, tom lane

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: VACUUM and transaction ID wraparound
Следующее
От: Tom Lane
Дата:
Сообщение: Re: - what protocol for an Internet postgres