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 35B753ABE34 for ; Wed, 29 Dec 2004 17:21:33 +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 65963-07 for ; Wed, 29 Dec 2004 17:21:22 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.207]) by svr1.postgresql.org (Postfix) with ESMTP id 4883E3A19D2 for ; Wed, 29 Dec 2004 17:21:20 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 49so331769wri for ; Wed, 29 Dec 2004 09:21:20 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=Lcl+44g6yhLeNTzN3GoozIAEeZWPANSrEgaZfg77z/HLPqEus3nQ6NCu3zmCn0MuO2B4nNpj0j+2xlVJknHZODrRsX81y0P1Vp2vKnr4Z5cvpvX8COMA6xSRIVddYv9QwCHNb7fyRDbbSJO/H1Qe3GFZ9SK7LM+pGuerqMc7NrE= Received: by 10.54.17.23 with SMTP id 23mr189238wrq; Wed, 29 Dec 2004 09:21:20 -0800 (PST) Received: by 10.54.59.22 with HTTP; Wed, 29 Dec 2004 09:21:20 -0800 (PST) Message-ID: <330532b604122909216fccf38c@mail.gmail.com> Date: Wed, 29 Dec 2004 12:21:20 -0500 From: Mitch Pirtle Reply-To: Mitch Pirtle To: Matthew Terenzio Subject: Re: too many clients Cc: pgsql-php@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <0DC9A380-59AB-11D9-B3B3-0003938BDF32@localnotion.com> <330532b604122908387f7ffde2@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200412/4 X-Sequence-Number: 2962 On Wed, 29 Dec 2004 12:12:13 -0500, Matthew Terenzio wrote: > > On Dec 29, 2004, at 11:38 AM, Mitch Pirtle wrote: > > 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. It is, but I am told that it is not really very efficient, and so pg_connect will actually give you better performance on heavy-load sites. Again, I've heard this but cannot substantiate. > How is a connection pool more efficient in doing something along these > lines? The pool is specifically designed to do just that - manage connections and keep existing ones maintained - so it is lightweight and fast. You can get more info here: http://sqlrelay.sourceforge.net/sqlrelay/faq.html I've used it for Oracle-powered sites, as well as putting something sane between zope/plone and both Oracle and MS SQL. -- Mitch