| 类型: | real |
| 默认: | 2 (2ms) |
| 最低限度: | -1 (-1) |
| 最大: | 100 (100ms) |
| 单元: | milliseconds (ms) |
| 上下文: | sighup |
| 重新开始: | false |
指定用于自动VACUUM操作中的代价延迟值。如果指定-1（默认值），则使用vacuum_cost_delay值。 如果指定值时没有单位，则以毫秒为单位。默认值为2毫秒。该参数只能在postgresql.conf文件或在服务器命令中设置。但是对个别表可以通过修改表存储参数来覆盖该设置。
建议 [EN]
If autovacuum is having too much of a performance impact on running queries, you might want to increase this setting to 50ms. However, this will also cause individual vacuum tasks to take longer.
在 StackOverflow
- What is autovacuum_vacuum_cost_delay in autovacuum in PostgreSQL?
- Postgres auto-vacuum doesn't reclaim the dead tuples space causes disk full issue
- is there any adverse effect on DB if I set autovacuum scale factor to zero for certain tables?
- Need clarification related to Autovacuum configuration parameters
- vacuum_cost_page_miss set to zero
在 pgsql-hackers
- Running autovacuum dynamic update to cost_limit and delay
- Re: [BUG] Autovacuum not dynamically decreasing cost_limit and cost_delay
- We should stop telling users to "vacuum that database in single-user mode"
- automatic analyze: readahead - add "IO read time" log message
- Re: automatic analyze: readahead - add "IO read time" log message