Received: from ctron-dnm.ctron.com (ctron-dnm.cabletron.com [12.25.1.120]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f79ChGP19214 for ; Thu, 9 Aug 2001 08:43:16 -0400 (EDT) (envelope-from rhunter@enterasys.com) Received: (from uucp@localhost) by ctron-dnm.ctron.com (8.8.7/8.8.7) id IAA20553 for ; Thu, 9 Aug 2001 08:50:42 -0400 (EDT) Received: from unknown(134.141.77.96) by ctron-dnm.ctron.com via smap (4.1) id xma020527; Thu, 9 Aug 01 08:50:04 -0400 Received: by cnc-exc1.ctron.com with Internet Mail Service (5.5.2653.19) id ; Thu, 9 Aug 2001 08:42:28 -0400 Message-ID: <59358A738F45D51186A30008C74CE2500A0844@slc-exc1.ctron.com> From: "Hunter, Ray" To: "Pgsql-php (E-mail)" Subject: RE: pg_connect vs. pg_pconnect Date: Thu, 9 Aug 2001 08:42:25 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C120D0.BE2D97F0" X-Archive-Number: 200108/4 X-Sequence-Number: 499 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C120D0.BE2D97F0 Content-Type: text/plain; charset="iso-8859-1" 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" To: 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 > ------_=_NextPart_001_01C120D0.BE2D97F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: [PHP] pg_connect vs. pg_pconnect

I am using both.  When I use pg_pconnect it seems th= at the connections are still sleeping even after I close the connection ( p= g_close( $conn ) ).

 
 
 
 
RAY HUNTER
Automated Test Group
Software Support Engineer
 
ENTERASYS NETWORKS
 
Internal:    53888
Phone:       801 887-9888<= /FONT>
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&= gt;
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 function= s.  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 proc= ess is then terminated?
> These sleeping connections are eating up my resourc= es.
>
>
> 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
>

------_=_NextPart_001_01C120D0.BE2D97F0--