Manage
CO.NF for your Blog
Configuration Snippet Parameter Snippet

autovacuum_freeze_max_age

  1. Documentation
  2. Autovacuum
  3. autovacuum_freeze_max_age
COPY SHARING LINK
Type: integer
Default: 200000000
Min: 100000
Max: 2000000000
Context: postmaster
Restart: true
Age at which to autovacuum a table to prevent transaction ID wraparound

Specifies the maximum age (in transactions) that a table's pg_class.relfrozenxid field can attain before a VACUUM operation is forced to prevent transaction ID wraparound within the table. Note that the system will launch autovacuum processes to prevent wraparound even when autovacuum is otherwise disabled.

Vacuum also allows removal of old files from the pg_xact subdirectory, which is why the default is a relatively low 200 million transactions. This parameter can only be set at server start, but the setting can be reduced for individual tables by changing table storage parameters. For more information see vacuum-for-wraparound.

Official docs

Search in source code

Recommendations

Triggers autovacuum automatically if a table is about to suffer from XID rollover. The setting is very conservative, and should probably be increased to 500million, but not higher.
By annotated.conf

Comments