Re: [HACKERS] Aggressive freezing in lazy-vacuum - Mailing list pgsql-patches

From Florian G. Pflug
Subject Re: [HACKERS] Aggressive freezing in lazy-vacuum
Date
Msg-id 45EC7274.20502@phlo.org
Whole thread Raw
In response to Re: [HACKERS] Aggressive freezing in lazy-vacuum  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-patches
Heikki Linnakangas wrote:
> 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.

Ok, that explains why I didn't find it when I checked the source - I
checked the 8.1 sources by accident ;-)

Anyway, thanks for pointing that out ;-)

greetings, Florian Pflug

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Heap page diagnostic/test functions (WIP)
Next
From: "Simon Riggs"
Date:
Subject: Re: Heap page diagnostic/test functions (WIP)