Re: Idea for getting rid of VACUUM FREEZE on cold pages

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Idea for getting rid of VACUUM FREEZE on cold pages
Дата
Msg-id 2390.1275661137@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Idea for getting rid of VACUUM FREEZE on cold pages  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: Idea for getting rid of VACUUM FREEZE on cold pages  (Robert Haas <robertmhaas@gmail.com>)
Re: Idea for getting rid of VACUUM FREEZE on cold pages  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Idea for getting rid of VACUUM FREEZE on cold pages  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Jan Wieck <JanWieck@Yahoo.com> writes:
> On 6/2/2010 3:10 PM, Alvaro Herrera wrote:
>> I'd prefer a setting that would tell the system to freeze all tuples
>> that fall within a safety range whenever any tuple in the page is frozen
>> -- weren't you working on a patch to do this?  (was it Jeff Davis?)

> I just see a lot of cost caused by this "safety range". I yet have to 
> see its real value, other than "feel good".

Jan, you don't know what you're talking about.  I have repeatedly had
cases where being able to look at xmin was critical to understanding
a bug.  I *will not* hold still for a solution that effectively reduces
min_freeze_age to zero.
        regards, tom lane


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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Synchronization levels in SR
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] Fix leaky VIEWs for RLS