diff options
author | Bruce Momjian <bruce@momjian.us> | 2011-09-06 11:08:34 -0400 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2011-09-06 11:08:34 -0400 |
commit | f85adb65bf2842c258e4c2d2930569e3b702c7d6 (patch) | |
tree | 0b5e2a5ee5bdb244626c8b30b9c32810a69cf2ac | |
parent | 0603ba3415f2fa6182248a6b96973224507543d3 (diff) | |
download | postgresql-f85adb65bf2842c258e4c2d2930569e3b702c7d6.tar.gz |
Properly document semphore requirements by accounting for worker
processes.
Backpatch to 9.1 and 9.0.
Submitted by Anton Yuzhaninov, confirmed by Robert Haas
-rw-r--r-- | doc/src/sgml/runtime.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 5098aad130..68ceff1530 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -604,13 +604,13 @@ psql: could not connect to server: No such file or directory <row> <entry><varname>SEMMNI</></> <entry>Maximum number of semaphore identifiers (i.e., sets)</> - <entry>at least <literal>ceil((max_connections + autovacuum_max_workers) / 16)</literal></> + <entry>at least <literal>ceil((max_connections + autovacuum_max_workers + 4) / 16)</literal></> </row> <row> <entry><varname>SEMMNS</></> <entry>Maximum number of semaphores system-wide</> - <entry><literal>ceil((max_connections + autovacuum_max_workers) / 16) * 17</literal> plus room for other applications</> + <entry><literal>ceil((max_connections + autovacuum_max_workers + 4) / 16) * 17</literal> plus room for other applications</> </row> <row> @@ -685,7 +685,7 @@ psql: could not connect to server: No such file or directory linkend="sysvipc-parameters">). The parameter <varname>SEMMNI</> determines the limit on the number of semaphore sets that can exist on the system at one time. Hence this parameter must be at - least <literal>ceil((max_connections + autovacuum_max_workers) / 16)</>. + least <literal>ceil((max_connections + autovacuum_max_workers + 4) / 16)</>. Lowering the number of allowed connections is a temporary workaround for failures, which are usually confusingly worded <quote>No space |