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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot