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

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Don't count background workers against a user's connection limit
Date: 2017-02-01 23:00:38
Message-ID: E1cZ3tG-0005Jj-MN@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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
------
REL9_6_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/13752743bf7010f7cbf07bdf2a0087c3960121c5

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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2017-02-01 23:02:52 pgsql: Don't count background workers against a user's connection limit
Previous Message Tom Lane 2017-02-01 22:18:39 pgsql: Fix CatalogTupleInsert/Update abstraction for case of shared ind