Re: [PATCHES] Aggressive freezing in lazy-vacuum - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: [PATCHES] Aggressive freezing in lazy-vacuum
Date
Msg-id 45EC6FB8.8090603@enterprisedb.com
Whole thread Raw
In response to Re: Aggressive freezing in lazy-vacuum  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: [PATCHES] Aggressive freezing in lazy-vacuum
List pgsql-hackers
Florian G. Pflug wrote:
> There could be a GUC vacuum_freeze_limit, and the actual FreezeLimit
> would be calculated as
> GetOldestXmin() - vacuum_freeze_limit

We already have that. It's called vacuum_freeze_min_age, and the default
is 100 million transactions.

IIRC we added it late in the 8.2 release cycle when we changed the clog
truncation point to depend on freeze limit.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: Aggressive freezing in lazy-vacuum
Next
From: Bruce Momjian
Date:
Subject: My time off