Re: Visibility map and freezing - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Visibility map and freezing
Date
Msg-id 494A2405.1040201@gmx.net
Whole thread Raw
In response to Visibility map and freezing  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Visibility map and freezing  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas wrote:
> I think we need a threshold similar to autovacuum_freeze_max_age for 
> manual vacuums as well: vacuum_freeze_max_age. If you run VACUUM, and 
> relfrozenxid is older than vacuum_freeze_max_age, the visibility map is 
> ignored and all pages are scanned.

Would one parameter to control both suffice?  (i.e., rename 
autovacuum_freeze_max_age to vacuum_freeze_max_age)


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: uuids on freebsd
Next
From: Heikki Linnakangas
Date:
Subject: Re: Visibility map and freezing