Re: Proposal: vacuum and autovacuum parameters to control freezing

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Proposal: vacuum and autovacuum parameters to control freezing
Дата
Msg-id 1162751095.3587.930.camel@silverbirch.site
обсуждение исходный текст
Ответ на Re: Proposal: vacuum and autovacuum parameters to control freezing  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Proposal: vacuum and autovacuum parameters to control freezing  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Proposal: vacuum and autovacuum parameters to control freezing  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
On Sun, 2006-11-05 at 12:01 -0500, Tom Lane wrote:

> After re-reading the above, it strikes me that maybe names based around
> "freeze_min" and "freeze_max" would be useful?

Works for me. They are clearly related, yet different and allow a
straightforward explanation of their need and use.

e.g.

vacuum_freeze_min    The latest TransactionId that will be "frozen" during
a VACUUM is calculated by CurrentTransactionId - vacuum_freeze_min.

vacuum_freeze_max
The maximum age, calculated as distance from CurrentTransactionId, that
will be allowed before a autovacuum will be forced for that database
object.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com




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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: [PATCHES] Bug in WAL backup documentation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Proposal: vacuum and autovacuum parameters to control freezing