Re: pg_pconnect - ??

Very true -- persistent connections are only going to give you a performance
gain of the time it takes to start a new PG process. That gain can matter
and matter a lot in certain situations but generally only with high-traffic
servers. Be careful, it's easy to run out of resources especially if you
have your PG processes set to use a good amount of sort/shared memory (and
you really should increase it from the default settings to get much better
performance)

Good luck!

-Mitch

----- Original Message -----
From: "Frank Bax" <fbax(at)sympatico(dot)ca>
To: "Chris Ruprecht" <chrup999(at)yahoo(dot)com>
Cc: "PostGreSQL PHP Group" <pgsql-php(at)postgresql(dot)org>
Sent: Monday, January 28, 2002 12:19 PM
Subject: Re: [PHP] pg_pconnect - ??

> 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(at)postgresql(dot)org
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>