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 29103.1250203570@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? )  (Jeff Davis <pgsql@j-davis.com>)
Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? )  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Jeff Davis <pgsql@j-davis.com> writes:
> Let's say that we had a range like 50-100M, where if it's older than
> 100M, we freeze it, and if it's older than 50M we freeze it only if it's
> on a dirty page. We would still have forensic evidence, but we could
> make a range such that we avoid writing multiple times.

Yeah, making the limit "slushy" would doubtless save some writes, with
not a lot of downside.

> And people who don't care about forensic evidence can set it to 0-100M.

Everybody *thinks* they don't care about forensic evidence.  Until they
need it.
        regards, tom lane


pgsql-hackers by date:

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