diff options
| author | Bruce Momjian <bruce@momjian.us> | 2011-09-06 11:08:35 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2011-09-06 11:08:35 -0400 |
| commit | 38052a9dbc90305b8f1fa5b87cbd7099778e66ab (patch) | |
| tree | 73ec12814684f815577f5c114636c8c585adf85c | |
| parent | e6d4288c514bc7bab1d48bc5a733606d1f57dba9 (diff) | |
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 01599af5c5c..d11c5bc8cfc 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -597,13 +597,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> @@ -678,7 +678,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 |