Received: from mail.cablespeed.com (mail.cablespeed.com [206.112.192.76]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7909M650174 for ; Wed, 8 Aug 2001 20:09:22 -0400 (EDT) (envelope-from mvincent@cablespeed.com) Received: from epox450 (216-93-124-123.mdmmi.voyager.net [216.93.124.123]) by mail.cablespeed.com (8.9.3/8.9.3) with SMTP id RAA10996; Wed, 8 Aug 2001 17:08:26 -0700 Message-ID: <00b301c12067$9259bf00$0b51000a@epox450> From: "Mitch Vincent" To: "Hunter, Ray" , References: <59358A738F45D51186A30008C74CE2500A0843@slc-exc1.ctron.com> Subject: Re: pg_connect vs. pg_pconnect Date: Wed, 8 Aug 2001 20:09:34 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200108/3 X-Sequence-Number: 498 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 >