Database Reference
In-Depth Information
F
autovacuum_freeze_max_age
F
autovacuum_max_workers
F
autovacuum_naptime
F
autovacuum_vacuum_cost_delay
F
autovacuum_vacuum_cost_limit
F
autovacuum_vacuum_scale_factor
F
autovacuum_vacuum_threshold
F
log_autovacuum_min_duration
Individual tables can be controlled by "storage parameters", which are set using the following:
ALTER TABLE mytable SET (storage_parameter = value);
The storage parameters that relate to maintenance are as follows:
F
autovacuum_enabled
F
autovacuum_vacuum_cost_delay
F
autovacuum_vacuum_cost_limit
F
autovacuum_vacuum_scale_factor
F
autovacuum_vacuum_threshold
F
autovacuum_freeze_min_age
F
autovacuum_freeze_max_age
F
autovacuum_freeze_table_age
F
autovacuum_analyze_scale_factor
F
autovacuum_analyze_threshold
and "toast" tables can be controlled with the following parameters:
F
toast.autovacuum_enabled
F
toast.autovacuum_vacuum_cost_delay
F
toast.autovacuum_vacuum_cost_limit
F
toast.autovacuum_vacuum_scale_factor
F
toast.autovacuum_vacuum_threshold
F
toast.autovacuum_freeze_min_age
F
toast.autovacuum_freeze_max_age
F
toast.autovacuum_freeze_table_age
F
toast.autovacuum_analyze_scale_factor
F
toast.autovacuum_analyze_threshold