Re: Idea for getting rid of VACUUM FREEZE on cold pages - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Idea for getting rid of VACUUM FREEZE on cold pages
Date
Msg-id 2390.1275661137@sss.pgh.pa.us
Whole thread Raw
In response to Re: Idea for getting rid of VACUUM FREEZE on cold pages  (Jan Wieck <JanWieck@Yahoo.com>)
Responses 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>)
List 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 by date:

Previous
From: David Fetter
Date:
Subject: Re: Synchronization levels in SR
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Fix leaky VIEWs for RLS