VACUUM Parameters
| Name | Description | Default Value |
|---|---|---|
| track_counts | Specifies whether to enable the statistics collection function. | on |
| AutoVacuum | Specifies whether to enable the automatic cleanup function. | on |
| AutoVacuum_mode | Specifies whether Autoanalyze or AutoVacuum is enabled. This parameter is valid only when AutoVacuum is set to on. | mix |
| autovacuum_max_workers | Specifies the maximum number of working processes that can be automatically cleared. | 3 |
| autovacuum_naptime | Specifies the interval between two automatic vacuum operations. | 10min |
| autovacuum_vacuum_cost_limit | Specifies the upper limit of the cost used in AutoVacuum. | 1000 |
| autovacuum_vacuum_cost_delay | Specifies the sleep time required if the cost exceeds the upper limit. | 20ms |
| vacuum_freeze_min_age | Specifies the upper limit of tuple age. The tuple needs to be frozen if this upper limit is exceeded. | 2000000000 |
| autovacuum_freeze_max_age | Specifies the upper limit of table age. AutoVacuum needs to be forcibly started if this upper limit is exceeded. | 4000000000 |
| vacuum_freeze_table_age | Specifies the upper limit of table age. The emergency mode needs to be executed if this upper limit is exceeded. | 4000000000 |
| autovacuum_vacuum_threshold | Specifies the threshold for AutoVacuum to perform VACUUM. | 50 |
| autovacuum_vacuum_scale_factor | Specifies the AutoVacuum factor, which is the scale factor for AutoVacuum to perform VACUUM. | 0.2 |
| autovacuum_analyze_threshold | Specifies the threshold for AutoVacuum to perform ANALYZE. | 50 |
| autovacuum_analyze_scale_factor | Specifies the autoanalyze factor, which is the scale factor for AutoVacuum to perform ANALYZE. | 0.1 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
