System Catalogs / System catalogs
pg_autovacuum
Read the PG 8.3 manualThe catalog pg_autovacuum stores optional per-relation configuration parameters for the autovacuum daemon.
Reading PG 8.3·documented in 3 of 24 versions, 8.1 to 8.3
Historical documentation for a PostgreSQL version that is no longer supported.
- Kind
- System catalogs
- Columns in this snapshot
- 10
- Definition source
- English manual
Columns 10
| Column | Type | Description / reference |
|---|---|---|
vacrelid | oid | The table this entry is for pg_class.oid |
enabled | bool | If false, this table will not be autovacuumed, except to prevent transaction ID wraparound |
vac_base_thresh | integer | Minimum number of modified tuples before vacuum |
vac_scale_factor | float4 | Multiplier for reltuples to add to vac_base_thresh |
anl_base_thresh | integer | Minimum number of modified tuples before analyze |
anl_scale_factor | float4 | Multiplier for reltuples to add to anl_base_thresh |
vac_cost_delay | integer | Custom vacuum_cost_delay parameter |
vac_cost_limit | integer | Custom vacuum_cost_limit parameter |
freeze_min_age | integer | Custom vacuum_freeze_min_age parameter |
freeze_max_age | integer | Custom autovacuum_freeze_max_age parameter |
Column history across versions
Definition snapshot: english-manuals:d6714b5a41452274326fb6c6062… · English manual source