On Sat, Jan 10, 2015 at 6:20 AM, Jim Nasby <jim.na...@bluetreble.com> wrote: > > 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 this in the max_connecitons section of the documents by doing s/connections/user connections/ and including the formula for MaxBackends (MaxBackends = MaxConnections + autovacuum_max_workers + 1 + max_worker_processes). I'll also mention that any postgres_fdw connections are considered user connections. >
I think it makes sense to add such a clarification in docs, however not sure if specifying along with max_connections parameter is good idea as the formula is somewhat internal and is not directly related to max_connections. How about specifying in below page: http://www.postgresql.org/docs/devel/static/connect-estab.html > > Also, my understanding is that the parallel stuff will continue to fall under max_worker_processes? Yes. With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
