Toggle navigation

autovacuum_vacuum_cost_delay

类型: integer
默认: 20
最低限度: -1
最大: 100
单元: milliseconds (ms)
上下文: sighup
重新开始: false

指定用于自动VACUUM操作中的代价延迟值。如果指定-1(默认值),则使用vacuum_cost_delay值。默认值为20毫秒。该参数只能在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.

条评论