类型: | integer |
默认: | 60 (1min) |
最低限度: | 1 (1s) |
最大: | 2147483 (2147483s) |
单元: | seconds (s) |
上下文: | sighup |
重新开始: | false |
指定自动清理在任意给定数据库上运行的最小延迟。在每一轮中后台进程检查数据库并根据需要为数据库中的表发出VACUUM和ANALYZE命令。 如果指定值时没有单位,则以秒为单位。默认值为1分钟(1min
)。该参数只能在postgresql.conf文件或在服务器命令行上设置。
建议 [EN]
Decrease this to 30s or 15s if you have a large number (100's) of tables, or if you otherwise see from pg_stat_user_tables that autovacuum is not keeping up.
在 StackOverflow
在 pgsql-hackers
- Re: How about a psql backslash command to show GUCs?
- Re: Bug fix. autovacuum.c do_worker_start() associates memory allocations with TopMemoryContext rather than 'Autovacuum start worker (tmp)'
- Re: Making autovacuum logs indicate if insert-based threshold was the triggering condition
- Stabilizing the test_decoding checks, take N
- Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations