From 95a6dbf12b2aa7261cd6f13f41cc8de8a693ee75 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 23 Feb 2004 20:46:16 +0000 Subject: Do a direct probe during postmaster startup to determine the maximum number of openable files and the number already opened. This eliminates depending on sysconf(_SC_OPEN_MAX), and allows much saner behavior on platforms where open-file slots are used up by semaphores. --- doc/src/sgml/runtime.sgml | 23 +++++++++-------------- 1 file changed, 9 insertions(+), 14 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 8232ddc664c..64b4d11d18b 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ @@ -928,19 +928,14 @@ SET ENABLE_SEQSCAN TO OFF; Sets the maximum number of simultaneously open files allowed to each - server subprocess. The default is 1000. The limit actually used - by the code is the smaller of this setting and the result of - sysconf(_SC_OPEN_MAX). Therefore, on systems - where sysconf returns a reasonable limit, you don't - need to worry about this setting. But on some platforms - (notably, most BSD systems), sysconf returns a - value that is much larger than the system can really support - when a large number of processes all try to open that many - files. If you find yourself seeing Too many open files - failures, try reducing this setting. This option can only be set - at server start or in the postgresql.conf - configuration file; if changed in the configuration file, it - only affects subsequently-started server subprocesses. + server subprocess. The default is 1000. If the kernel is enforcing + a safe per-process limit, you don't need to worry about this setting. + But on some platforms (notably, most BSD systems), the kernel will + allow individual processes to open many more files than the system + can really support when a large number of processes all try to open + that many files. If you find yourself seeing Too many open + files failures, try reducing this setting. + This option can only be set at server start. -- cgit v1.2.3