I'm surprised to see that the docs make no mention of how max_connections, max_worker_processes and
autovacuum_max_workers(don't) relate. I couldn't remember and had to actually look at the code. I'd like to clarify
thisin the max_connecitons section of the documents by doing s/connections/user connections/ and including the formula
forMaxBackends (MaxBackends = MaxConnections + autovacuum_max_workers + 1 + max_worker_processes). I'll also mention
thatany postgres_fdw connections are considered user connections.
Objections? Comments?
Also, my understanding is that the parallel stuff will continue to fall under max_worker_processes?
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com