pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frank Bax <fbax@sympatico.ca>
To: Chris Ruprecht <chrup999@yahoo.com>
Cc: PostGreSQL PHP Group <pgsql-php@postgresql.org>
Subject: Re: pg_pconnect - ??
Date: Mon, 28 Jan 2002 14:19:57 -0500
Message-ID: <3.0.6.32.20020128141957.02130660@pop6.sympatico.ca> (raw)
In-Reply-To: <p0510120cb87b23a62b3d@[192.168.0.6]>

The connection will only be reused if the *same* apache child process
handles the request.  You should expect to see many postgres client
connections.
A) Each database/user connection combination.
B) Each apache child process

Multiply A*B to get max number of concurrent connections.  If A*B can go
over postgres connection limit, then you might start getting connection
refused messages.

If your postgres database is on the same server as you webserver, there is
neglible gains for using pconnect over connect.

Frank


At 09:56 AM 1/28/02 -0600, Chris Ruprecht wrote:
>Hi all,
>
>I am under the assumtion that, when I do a pg_pconnect instead of a 
>pg_connect, the connection to the db I have established, can be used 
>by another PHP procedure. Somehow, I don't see this working the way I 
>expect it.
>When I initially connect with pconnect, I see a postgres session 
>staring up and everything works. The postgres process stays active 
>but when I pconnect again, a second process is started. I was 
>expecting that the same process from the first pconnect will be used. 
>At the end, I land up with a whole bunch of postgres client sessions 
>hanging around in the system, doing who knows what.
>
>What am I missing (doing wrong) here?
>Postgres = 7.1.3, OS = Linux 2.4.9 (RedHat 7.2), PHP = 4.0.6, Apache 
>= 1.3.22, memory = plenty (768 MB)
>
>Best regards,
>Chris
>-- 
>Chris Ruprecht
>Network grunt and bit pusher extraordinaíre
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>



view thread (26+ messages)  latest in thread

Message-ID: <3.0.6.32.20020128141957.02130660@pop6.sympatico.ca>
Permalink:  ../3.0.6.32.20020128141957.02130660@pop6.sympatico.ca/
Also on:    postgresql.org/message-id/3.0.6.32.20020128141957.02130660@pop6.sympatico.ca

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: fbax@sympatico.ca, chrup999@yahoo.com
  Subject: Re: pg_pconnect - ??
  In-Reply-To: <3.0.6.32.20020128141957.02130660@pop6.sympatico.ca>
  References: <p0510120cb87b23a62b3d@[192.168.0.6]> <3.0.6.32.20020128141957.02130660@pop6.sympatico.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox