Updated on 2025-05-29 GMT+08:00

VACUUM Parameters

Table 1 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