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
 
Search WWH ::




Custom Search