Manage
CO.NF for your Blog
Configuration Snippet Parameter Snippet

autovacuum_vacuum_insert_scale_factor

  1. Documentation
  2. Autovacuum
  3. autovacuum_vacuum_insert_scale_factor
COPY SHARING LINK
Type: real
Default: 0.2
Min: 0
Max: 100
Context: sighup
Restart: false
Since: 13
Number of tuple inserts prior to vacuum as a fraction of reltuples

Specifies a fraction of the table size to add to autovacuum_vacuum_insert_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.

Official docs

Search in source code

Comments