PostgreSQL Documentation: autovacuum_max

Type:	`integer`
Default:	`3`
Min:	`1`
Max:	`262143`
Context:	`postmaster`
Restart:	`true`

Sets the maximum number of simultaneously running autovacuum worker processes

Specifies the maximum number of autovacuum processes (other than the autovacuum launcher) that may be running at any one time. The default is three. This parameter can only be set at server start.

Official docs

Search in source code

Recommendations

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.

By annotated.conf

On StackOverflow

What exactly means the collation 'de-DE-u-kn-true'
De-Identifying PHI For HIPAA
Lazily (de-)serialize JSON with EF Core
Connect to a heroku database with pgadmin
Get breakdown from de-normalized SQL table

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: Regression tests fail on OpenBSD due to low semmns value
Re: remove check hooks for GUCs that contribute to MaxBackends

autovacuum_max_workers

Recommendations

On StackOverflow

On pgsql-hackers

Comments