类型: | integer |
默认: | 3 |
最低限度: | 1 |
最大: | 262143 |
上下文: | postmaster |
重新开始: | true |
指定能同时运行的自动清理进程(除了自动清理启动器之外)的最大数量。默认值为3。该参数只能在服务器启动时设置。
建议 [EN]
If you have an installation with many tables (100's to 1000's) or with some tables which autovacuum takes hours to process, you may want to add additional autovacuum workers so that multiple tables can be vacuumed at once. Be conservative, though, as each autovacuum worker will utilize a separate CPU core, memory and I/O.
在 StackOverflow
在 pgsql-hackers
- Re: allow changing autovacuum_max_workers without restarting
- Re: scalability bottlenecks with (many) partitions (and more)
- remove check hooks for GUCs that contribute to MaxBackends
- Re: Regression tests fail on OpenBSD due to low semmns value
- Re: remove check hooks for GUCs that contribute to MaxBackends