Type: | integer |
Défaut: | 3 |
Min: | 1 |
Max: | 262143 |
Contexte: | postmaster |
Redémarrer: | true |
Indique le nombre maximum de processus autovacuum (autre que le lanceur d'autovacuum) qui peuvent être exécutés simultanément. La valeur par défaut est 3. Ce paramètre ne peut être configuré qu'au lancement du serveur.
Recommandations [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.
Sur StackOverflow
Sur pgsql-hackers
- Re: allow changing autovacuum_max_workers without restarting
- BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences
- Re: confusion about this commit "Revert "Skip redundant anti-wraparound vacuums""
- allow changing autovacuum_max_workers without restarting