Table age that forces an anti-wraparound autovacuum.
At a glance
| Property | Value |
|---|---|
| Parameter | autovacuum_freeze_max_age |
| Category | Autovacuum |
| Default | 200000000 |
| Value type | boolean / enum / numeric |
| Change scope | Restart required |
What it does
Maximum transaction age a table reaches before a forced (anti-wraparound) autovacuum runs, even if autovacuum is off. Prevents transaction-ID wraparound.
How to apply a change
Requires a full server restart (postmaster context). Set it in postgresql.conf and restart PostgreSQL.
Inspect the current value and source with SHOW autovacuum_freeze_max_age; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'autovacuum_freeze_max_age';.
Tuning guidance
Rarely change. If aggressive anti-wraparound vacuums disrupt load, ensure normal autovacuum keeps tables young rather than raising this toward the 2-billion hard limit.