| Type: | integer |
| Default: | -1 |
| Min: | -1 |
| Max: | 10000 |
| Context: | sighup |
| Restart: | false |
Specifies the cost limit value that will be used in automatic VACUUM operations. If -1 is specified (which is the default), the regular vacuum_cost_limit value will be used. Note that the value is distributed proportionally among the running autovacuum workers, if there is more than one, so that the sum of the limits for each worker does not exceed the value of this variable. 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.
On StackOverflow
On pgsql-hackers
- Re: Track the amount of time waiting due to cost_delay
- A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.
- Re: Allow non-superuser to cancel superuser tasks.
- Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection