Re: Why is vacuum_freeze_min_age 100m?

Поиск
Список
Период
Сортировка
От Torsten Zühlsdorff
Тема Re: Why is vacuum_freeze_min_age 100m?
Дата
Msg-id h5tp40$5u4$1@news.eternal-september.org
обсуждение исходный текст
Ответ на Re: Why is vacuum_freeze_min_age 100m?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane schrieb:
> 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.

If there is not really much to gain by changing the value, why do not
remove the parameter?

Greetings from germany,
Torsten

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

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