Re: Why is vacuum_freeze_min_age 100m?
От
Kevin Grittner
Тема
Re: Why is vacuum_freeze_min_age 100m?
Дата
Msg-id
4A82EEE802000025000299AE@gw.wicourts.gov
Ответ на
Re: Why is vacuum_freeze_min_age 100m? (Tom Lane)
Список
Дерево обсуждения
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 по дате отправления