Toggle navigation

autovacuum_vacuum_insert_threshold

Type: integer
Default: 1000
Min: -1
Max: 2147483647
Context: sighup
Restart: false
Since: 13

Specifies the number of inserted tuples needed to trigger a VACUUM in any one table. The default is 1000 tuples. If -1 is specified, autovacuum will not trigger a VACUUM operation on any tables based on the number of inserts. 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