Don't count background workers against a user's connection limit.
Andrew Dunstan <andrew@dunslane.net>
Don't count background workers against a user's connection limit. Doing so doesn't seem to be within the purpose of the per user connection limits, and has particularly unfortunate effects in conjunction with parallel queries. Backpatch to 9.6 where parallel queries were introduced. David Rowley, reviewed by Robert Haas and Albe Laurenz.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/create_database.sgml | modified | +2 −1 |
| doc/src/sgml/ref/create_role.sgml | modified | +4 −1 |
| src/backend/access/transam/twophase.c | modified | +1 −0 |
| src/backend/storage/ipc/procarray.c | modified | +34 −0 |
| src/backend/storage/lmgr/proc.c | modified | +2 −0 |
| src/backend/utils/init/postinit.c | modified | +1 −1 |
| src/include/storage/procarray.h | modified | +1 −0 |
| src/include/storage/proc.h | modified | +2 −0 |