タイプ: | integer |
デフォルト: | 3 |
分: | 1 |
最大: | 262143 |
コンテキスト: | postmaster |
再起動: | true |
同時に実行することができるautovacuumプロセス(autovacuumランチャ以外)の最大数を指定します。デフォルトは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.
On StackOverflow
On 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: remove check hooks for GUCs that contribute to MaxBackends
- Re: Refactoring postmaster's code to cleanup after child exit