autovacuum_vacuum_scale_factor

Type: real
Default: 0.2
Min: 0
Max: 100
Context: sighup
Restart: false

Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size). This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters.

Comments