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 f78Nev643207 for ; Wed, 8 Aug 2001 19:40:57 -0400 (EDT) (envelope-from rhunter@enterasys.com) Received: (from uucp@localhost) by ctron-dnm.ctron.com (8.8.7/8.8.7) id TAA02845 for ; Wed, 8 Aug 2001 19:48:27 -0400 (EDT) Received: from unknown(134.141.77.96) by ctron-dnm.ctron.com via smap (4.1) id xma002841; Wed, 8 Aug 01 19:47:50 -0400 Received: by cnc-exc1.ctron.com with Internet Mail Service (5.5.2653.19) id ; Wed, 8 Aug 2001 19:40:16 -0400 Message-ID: <59358A738F45D51186A30008C74CE2500A0843@slc-exc1.ctron.com> From: "Hunter, Ray" To: pgsql-php@postgresql.org Subject: pg_connect vs. pg_pconnect Date: Wed, 8 Aug 2001 19:40:16 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C12063.7A03B900" X-Archive-Number: 200108/1 X-Sequence-Number: 496 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_01C12063.7A03B900 Content-Type: text/plain; charset="iso-8859-1" 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_01C12063.7A03B900 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable pg_connect vs. pg_pconnect

I understand the difference between the two functions.&nb= sp; 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 i= t so that when I connect to postgres and query that the connect process is = then terminated?  These sleeping connections are eating up my resource= s.


Any suggestions?
 
 
 
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

------_=_NextPart_001_01C12063.7A03B900--