Re: Why is vacuum_freeze_min_age 100m? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Why is vacuum_freeze_min_age 100m?
Date
Msg-id 1849.1250038484@sss.pgh.pa.us
Whole thread Raw
In response to Why is vacuum_freeze_min_age 100m?  (Josh Berkus <josh@agliodbs.com>)
Responses 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>)
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> I've just been tweaking some autovac settings for a large database, and
> came to wonder: why does vacuum_max_freeze_age default to such a high
> number?  What's the logic behind that?

(1) not destroying potentially useful forensic evidence too soon;
(2) there's not really much to be gained by reducing it.

            regards, tom lane

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Why is vacuum_freeze_min_age 100m?
Next
From: Robert Haas
Date:
Subject: Re: Why is vacuum_freeze_min_age 100m?