X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DB4C23AC153 for ; Wed, 29 Dec 2004 17:12:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62712-10 for ; Wed, 29 Dec 2004 17:12:15 +0000 (GMT) Received: from localnotion.com (localnotion.com [200.46.204.32]) by svr1.postgresql.org (Postfix) with ESMTP id 3CAFA3ABE34 for ; Wed, 29 Dec 2004 17:12:15 +0000 (GMT) Received: from [192.168.2.18] (ool-182c7886.dyn.optonline.net [24.44.120.134]) by localnotion.com (Postfix) with ESMTP id 12C64667336 for ; Wed, 29 Dec 2004 17:12:14 +0000 (GMT) Mime-Version: 1.0 (Apple Message framework v619) In-Reply-To: <330532b604122908387f7ffde2@mail.gmail.com> References: <0DC9A380-59AB-11D9-B3B3-0003938BDF32@localnotion.com> <330532b604122908387f7ffde2@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Matthew Terenzio Subject: Re: too many clients Date: Wed, 29 Dec 2004 12:12:13 -0500 To: pgsql-php@postgresql.org X-Mailer: Apple Mail (2.619) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/3 X-Sequence-Number: 2961 On Dec 29, 2004, at 11:38 AM, Mitch Pirtle wrote: > You got a couple solutions, one of which is getting a connection > pooler setup between apache(php) and postgres. SQL Relay > (sqlrelay.sf.net) could be a common candidate, as I have used it in > the past with great results. Yes, I have taken a look at that before. It might be a good time to try it. I don't exactly understand the technical difference between pooled connections and persistent ones. pg_pconnect() is grabbing an existing open connection if one is available. How is a connection pool more efficient in doing something along these lines? Thanks, Matt