Received: from neobis.elma.fr (neobis.elma.fr [213.41.14.131]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBDBehM70352 for ; Wed, 13 Dec 2000 06:40:52 -0500 (EST) (envelope-from herve@elma.fr) Received: from elma.fr (unknown [10.0.1.2]) by neobis.elma.fr (Postfix) with ESMTP id 7FB2A26FC3; Wed, 13 Dec 2000 12:44:00 +0100 (CET) Message-ID: <3A37602A.59D5FC2F@elma.fr> Date: Wed, 13 Dec 2000 12:40:26 +0100 From: =?iso-8859-1?Q?Herv=E9?= Piedvache Reply-To: herve@elma.fr Organization: Elma =?iso-8859-1?Q?Ing=E9nierie?= Informatique X-Mailer: Mozilla 4.75 [fr] (Win98; U) X-Accept-Language: fr,es-AR MIME-Version: 1.0 To: Alexey Borzov Cc: pgsql-php@postgresql.org Subject: Re: pg_pconnect - Really persistent ? References: <3A2E22FC.2E1A2C01@elma.fr> <1119521331.20001206150101@rdw.ru> <3A34A260.BB0E1490@elma.fr> <98912605.20001213110607@rdw.ru> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200012/18 X-Sequence-Number: 61 Hi Alexey, At first thanks for your answer ;) Alexey Borzov a écrit : > > HP> I do what you said ... but still have trouble with postgresql ... I have > HP> a message like too many files opened in same time ... on the postgresql > HP> server my max limit is 8192 files ... !! So to save my trouble for the > HP> moment the only way I found is to cron a apache graceful each minute ! > HP> :((( > Increase the limit on open files: now each postgres can have > 8192/256=32 open files max, and it needs to have much more... OK is 32768 is ok ? 32768/256=128 max files by backend ... I don't know (and would like to know if possible) what is the implication of this file-max for my server ? What is the maximimum size of the file max for a linux ? In fact that depends of what ? ;) > HP> # > HP> StartServers 20 > HP> MinSpareServers 64 > HP> MaxSpareServers 128 > HP> # > Isn't MaxSpareServers a bit high? At each given time you can have > 128 idle Apaches and each of these 2 idle Postgreses connected (256 > total), which is actually your limit. Ouch! I understand what you mean ... but you can see my Apache log file of today ... [Wed Dec 13 12:16:14 2000] [info] server seems busy, (you may need to increase StartServers, or Min/MaxSpareServers), spawning 8 children, there are 0 idle, and 39 total children [Wed Dec 13 12:16:15 2000] [info] server seems busy, (you may need to increase StartServers, or Min/MaxSpareServers), spawning 16 children, there are 0 idle, and 47 total children [Wed Dec 13 12:16:16 2000] [info] server seems busy, (you may need to increase StartServers, or Min/MaxSpareServers), spawning 32 children, there are 12 idle, and 63 total children [Wed Dec 13 12:16:17 2000] [info] server seems busy, (you may need to increase StartServers, or Min/MaxSpareServers), spawning 32 children, there are 45 idle, and 95 total children What can I do ... and why I'm in this case ? Many thanks per advance for your help ! regards, -- Hervé