RE: pg_connect vs. pg_pconnect - Mailing list pgsql-php

From Hunter, Ray
Subject RE: pg_connect vs. pg_pconnect
Date
Msg-id 59358A738F45D51186A30008C74CE2500A0844@slc-exc1.ctron.com
Whole thread Raw
In response to pg_connect vs. pg_pconnect  ("Hunter, Ray" <rhunter@enterasys.com>)
List pgsql-php

I am using both.  When I use pg_pconnect it seems that the connections are still sleeping even after I close the connection ( pg_close( $conn ) ).

 
 
 
 
RAY HUNTER
Automated Test Group
Software Support Engineer
 
ENTERASYS NETWORKS
 
Internal:    53888
Phone:       801 887-9888
Fax:         801 972-5789
Cellular:    801 698-0622

rhunter@enterasys.com
 
www.enterasys.com

-----Original Message-----
From: Mitch Vincent [mailto:mvincent@cablespeed.com]
Sent: Wednesday, August 08, 2001 6:10 PM
To: Hunter, Ray; pgsql-php@postgresql.org
Subject: Re: [PHP] pg_connect vs. pg_pconnect

If you're using pg_connect they should be terminating... Are you using
pg_connect or pg_pconnect?

-Mitch
Software development :
You can have it cheap, fast or working. Choose two.

----- Original Message -----
From: "Hunter, Ray" <rhunter@enterasys.com>
To: <pgsql-php@postgresql.org>
Sent: Wednesday, August 08, 2001 7:40 PM
Subject: [PHP] pg_connect vs. pg_pconnect

> I understand the difference between the two functions.  However, when I
> watch my process under process management I notice that I have tons of
> sleeping process that are lingering.  How can I make it so that when I
> connect to postgres and query that the connect process is then terminated?
> These sleeping connections are eating up my resources.
>
>
> Any suggestions?
>
>
>
> RAY HUNTER
> Automated Test Group
> Software Support Engineer
>
> ENTERASYS NETWORKS
>
> Internal:    53888
> Phone:       801 887-9888
> Fax:         801 972-5789
> Cellular:    801 698-0622
>
> rhunter@enterasys.com
>
> www.enterasys.com
>

pgsql-php by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: pg_connect vs. pg_pconnect
Next
From: "Hunter, Ray"
Date:
Subject: RE: pg_connect vs. pg_pconnect