pgsql: Don't count background workers against a user's connection limit

Started by Andrew Dunstanover 9 years ago1 messagescomitters
Jump to latest
#1Andrew 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.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/f1169ab501ce90e035a7c6489013a1d4c250ac92

Modified Files
--------------
doc/src/sgml/ref/create_database.sgml | 3 ++-
doc/src/sgml/ref/create_role.sgml | 5 ++++-
src/backend/access/transam/twophase.c | 1 +
src/backend/storage/ipc/procarray.c | 34 ++++++++++++++++++++++++++++++++++
src/backend/storage/lmgr/proc.c | 2 ++
src/backend/utils/init/postinit.c | 2 +-
src/include/storage/proc.h | 2 ++
src/include/storage/procarray.h | 1 +
8 files changed, 47 insertions(+), 3 deletions(-)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers