Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? )
Date
Msg-id 29393.1250204757@sss.pgh.pa.us
Whole thread Raw
In response to Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? )  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? )  (Josh Berkus <josh@agliodbs.com>)
Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? )  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Jeff Davis <pgsql@j-davis.com> writes:
> On Thu, 2009-08-13 at 18:46 -0400, Tom Lane wrote:
>> Everybody *thinks* they don't care about forensic evidence.  Until they
>> need it.

> We already allow setting vacuum_freeze_min_age to zero, so I don't see a
> solution here other than documentation.

Yeah, we allow it.  I just don't want to encourage it ... and definitely
not make it default.

What are you envisioning exactly?  If vacuum finds any reason to dirty
a page (or it's already dirty), then freeze everything on the page that's
got age > some lower threshold?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? )
Next
From: Josh Berkus
Date:
Subject: Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? )