diff options
| author | Bruce Momjian <bruce@momjian.us> | 2011-09-06 11:08:32 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2011-09-06 11:08:32 -0400 |
| commit | d764835bbc705f38311b5a6fe14a9aff4feb6fc3 (patch) | |
| tree | 1386cf6de804ba0d87ceb1c670cdfc0a2e5238cf /doc/src | |
| parent | 5c8676ea71754b5ebd4a5e4ad3ffb173ef6db32d (diff) | |
| download | postgresql-d764835bbc705f38311b5a6fe14a9aff4feb6fc3.tar.gz postgresql-d764835bbc705f38311b5a6fe14a9aff4feb6fc3.zip | |
Properly document semphore requirements by accounting for worker
processes.
Backpatch to 9.1 and 9.0.
Submitted by Anton Yuzhaninov, confirmed by Robert Haas
Diffstat (limited to 'doc/src')
| -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 5098aad130a..68ceff15303 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 |