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.