vacuum_freeze_table_age
No restart — settable per sessiontuned by pgconfiguratortransaction age (XIDs)
The table age at which a normal vacuum escalates to a full-table freeze scan.
What pgconfigurator would set
32 GB · 8 vCPU · NVMe · OLTP
Computing…
Tune for your exact server → /tunecomputed in your browser · nothing uploaded
What it does
Once a table's age exceeds this, the next vacuum scans the whole table (not just recently-changed pages) to freeze old rows, proactively heading off a forced anti-wraparound vacuum.
How to tune it
The default (150 million) is fine for most. It works with autovacuum_freeze_max_age: keeping vacuum_freeze_table_age comfortably below it means routine vacuums do the freezing gradually instead of a disruptive emergency vacuum hitting at the deadline.