Received: from zukerman-1.dsl.speakeasy.net (zukerman-1.dsl.speakeasy.net [216.254.75.142]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAM4Ods43013 for ; Tue, 21 Nov 2000 23:24:39 -0500 (EST) (envelope-from zukerman@math-hat.com) Received: from (matt.w80.math-hat.com) [216.254.75.141] by zukerman-1.dsl.speakeasy.net with esmtp (Exim 3.12 #1 (Debian)) id 13yRFf-00047W-00; Tue, 21 Nov 2000 23:11:19 -0500 Received: from zukerman by matt.w80.math-hat.com with local (Exim 3.16 #1 (Debian)) id 13yRQO-0006kf-00; Tue, 21 Nov 2000 23:22:24 -0500 To: Colleen Williams Cc: pgsql-sql@postgresql.org Subject: Re: Persistent Connects (pg_pconnect) References: <4.3.2.7.2.20001121122024.00b41aa8@192.168.1.253> From: Itai Zukerman Date: 21 Nov 2000 23:22:24 -0500 In-Reply-To: Colleen Williams's message of "Tue, 21 Nov 2000 12:34:19 +0000" Message-ID: <87d7foocu7.fsf@matt.w80.math-hat.com> Lines: 17 User-Agent: Gnus/5.0807 (Gnus v5.8.7) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200011/181 X-Sequence-Number: 212 On Tue, 21 Nov 2000 12:34:19 +0000, Colleen Williams wrote: > Each time one of us uses the CMS, a new > persistent connection process owned by postgres is started up. With 3 > people accessing the CMS sporadically, 32 persistent connections are > in existence and then Linux tells me there are too many connections! > Sometimes I believe existing connections are reused but not often! Not sure if this is related, but under the non-threading Apache server, you get 1 persistent connection per Apache process. I don't think you can be sure which process gets the page with the connection request, so if you have a limit of, say, 50 processes, and your server is hit fairly often, eventually you'll see 50 connections even though only a few simultaneous accesses to PHP/PostgreSQL are made. Or, I could be totally off. -itai