diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2017-02-01 17:52:35 -0500 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2017-02-01 18:02:43 -0500 |
| commit | f1169ab501ce90e035a7c6489013a1d4c250ac92 (patch) | |
| tree | 561667bd01bdfb5184853b65bccf1da5e326c1be /doc/src | |
| parent | aedd554f84bb3cedb32e6e2a954a70537a4da6b9 (diff) | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_database.sgml | 3 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_role.sgml | 5 |
2 files changed, 6 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_database.sgml b/doc/src/sgml/ref/create_database.sgml index cf33746c1e2..cf0d53b3014 100644 --- a/doc/src/sgml/ref/create_database.sgml +++ b/doc/src/sgml/ref/create_database.sgml @@ -258,7 +258,8 @@ CREATE DATABASE <replaceable class="PARAMETER">name</replaceable> The <literal>CONNECTION LIMIT</> option is only enforced approximately; if two new sessions start at about the same time when just one connection <quote>slot</> remains for the database, it is possible that - both will fail. Also, the limit is not enforced against superusers. + both will fail. Also, the limit is not enforced against superusers or + background worker processes. </para> </refsect1> diff --git a/doc/src/sgml/ref/create_role.sgml b/doc/src/sgml/ref/create_role.sgml index a3b8ed9ab4c..2ae576ede69 100644 --- a/doc/src/sgml/ref/create_role.sgml +++ b/doc/src/sgml/ref/create_role.sgml @@ -198,7 +198,10 @@ CREATE ROLE <replaceable class="PARAMETER">name</replaceable> [ [ WITH ] <replac <listitem> <para> If role can log in, this specifies how many concurrent connections - the role can make. -1 (the default) means no limit. + the role can make. -1 (the default) means no limit. Note that only + normal connections are counted towards this limit. Neither prepared + transactions nor background worker connections are counted towards + this limit. </para> </listitem> </varlistentry> |