vacuum_freeze_min_age
No restart — settable per sessiontuned by pgconfiguratortransaction age (XIDs)
How old a row must be before a vacuum will freeze it.
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
When a vacuum runs, it freezes row versions older than this transaction age. A lower value freezes more eagerly (more work now, less to do at wraparound time); a higher value defers freezing.
How to tune it
The default (50 million) balances eager and lazy freezing for most workloads. There's rarely a need to change it globally; insert-heavy time-series tables sometimes lower it so routine vacuums freeze as they go, avoiding a large freeze later.