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
>
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