autovacuum_vacuum_cost_delay
A configuration parameter specifying the cost delay value that will be used in autovacuum operations
autovacuum_vacuum_cost_delay
is a configuration parameter specifying the cost delay value that will be used in autovacuum operations.
autovacuum_vacuum_cost_delay
was added in PostgreSQL 8.1.
Default value
The default value for autovacuum_vacuum_cost_delay
is:
- PostgreSQL 12 and later:
2ms
- PostgreSQL 8.1 ~ PostgreSQL 11:
20ms
Change history
- PostgreSQL 12
- default changed from
20ms
to2ms
(commit cbccac37)
- default changed from
- PostgreSQL 8.1
- added (commit d90c5311)
References
- PostgreSQL documentation: autovacuum_vacuum_cost_delay
Categories
See also
autovacuum, autovacuum_vacuum_cost_limit