Re: Why is vacuum_freeze_min_age 100m?

Поиск
Список
Период
Сортировка
Искать
От
Kevin Grittner
Тема
Re: Why is vacuum_freeze_min_age 100m?
Дата
Msg-id
4A82EEE802000025000299AE@gw.wicourts.gov
Ответ на
Список
Дерево обсуждения
Why is vacuum_freeze_min_age 100m? Josh Berkus <josh@agliodbs.com>
freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Alvaro Herrera <alvherre@commandprompt.com>
Re: [HACKERS] freezing tuples ( was: Why is vacuum_freeze_min_age100m? ) "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Re: [HACKERS] freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Josh Berkus <josh@agliodbs.com>
Re: [HACKERS] freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Robert Haas <robertmhaas@gmail.com>
Re: Why is vacuum_freeze_min_age 100m? Tom Lane <tgl@sss.pgh.pa.us>
Re: Why is vacuum_freeze_min_age 100m? "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Why is vacuum_freeze_min_age 100m? Tom Lane <tgl@sss.pgh.pa.us>
Re: Why is vacuum_freeze_min_age 100m? "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Why is vacuum_freeze_min_age 100m? Tom Lane <tgl@sss.pgh.pa.us>
Re: Why is vacuum_freeze_min_age 100m? Robert Haas <robertmhaas@gmail.com>
Re: Why is vacuum_freeze_min_age 100m? "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Why is vacuum_freeze_min_age 100m? Torsten Zühlsdorff <foo@meisterderspiele.de>
Re: Why is vacuum_freeze_min_age 100m? Josh Berkus <josh@agliodbs.com>
Re: Why is vacuum_freeze_min_age 100m? Robert Haas <robertmhaas@gmail.com>
Re: Why is vacuum_freeze_min_age 100m? Josh Berkus <josh@agliodbs.com>
Re: Why is vacuum_freeze_min_age 100m? Robert Haas <robertmhaas@gmail.com>
Re: Why is vacuum_freeze_min_age 100m? Josh Berkus <josh@agliodbs.com>
Re: Why is vacuum_freeze_min_age 100m? Robert Haas <robertmhaas@gmail.com>
Tom Lane  wrote: 
 
> Hmmm ... if you're using VACUUM FREEZE, its behavior is unaffected
> by this GUC anyway --- that option makes it use a freeze age of
> zero.
 
Yeah, I know, but feel like I'm being a bit naughty in using VACUUM
FREEZE -- the documentation says:
 
| Selects aggressive "freezing" of tuples. Specifying FREEZE is
| equivalent to performing VACUUM with the vacuum_freeze_min_age
| parameter set to zero. The FREEZE option is deprecated and will be
| removed in a future release; set the parameter instead.
 
So I figure that since it is deprecated, at some point I'll be setting
the vacuum_freeze_min_age option rather than leaving it at the default
and using VACUUM FREEZE in the nightly maintenance run.
 
-Kevin
В списке pgsql-performance по дате отправления
От: Pierre Frédéric Caillaud
Дата:
От: Tom Lane
Дата:
FAQ