Re: Why is vacuum_freeze_min_age 100m?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why is vacuum_freeze_min_age 100m?
Дата
Msg-id 1849.1250038484@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Why is vacuum_freeze_min_age 100m?  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Why is vacuum_freeze_min_age 100m?
Re: Why is vacuum_freeze_min_age 100m?
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> I've just been tweaking some autovac settings for a large database, and
> came to wonder: why does vacuum_max_freeze_age default to such a high
> number?  What's the logic behind that?

(1) not destroying potentially useful forensic evidence too soon;
(2) there's not really much to be gained by reducing it.

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Why is vacuum_freeze_min_age 100m?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Why is vacuum_freeze_min_age 100m?