X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7084BD8431; Tue, 30 Aug 2005 14:34:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15866-07; Tue, 30 Aug 2005 17:34:18 +0000 (GMT) Received: from svctag-ckgvz71.mailserver.wazagua.com (unknown [209.34.245.244]) by svr1.postgresql.org (Postfix) with ESMTP id 80377D6E6B; Tue, 30 Aug 2005 14:34:17 -0300 (ADT) Received: from jfradkin ([66.15.127.235]) by svctag-ckgvz71.mailserver.wazagua.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 30 Aug 2005 13:33:20 -0400 From: "Joel Fradkin" To: , Subject: connections running out Date: Tue, 30 Aug 2005 13:35:39 -0400 Message-ID: <005b01c5ad89$3dcf7ca0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005C_01C5AD67.B6BDDCA0" X-OriginalArrivalTime: 30 Aug 2005 17:33:20.0984 (UTC) FILETIME=[EA691580:01C5AD88] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.896 required=5 tests=[AWL=-0.181, HTML_MESSAGE=0.001, MSGID_DOLLARS=3.076] X-Spam-Level: ** X-Archive-Number: 200508/389 X-Sequence-Number: 18708 This is a multi-part message in MIME format. ------=_NextPart_000_005C_01C5AD67.B6BDDCA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit My install using the new driver (ODBC) seems to have helped me a great deal. Unfortunately one of my night jobs uses a dynamic cube product that does a record set. I am not certain but I have the feeling it is leaving the connection open. After a few days (always at night when the program runs) I end up running out of connections (was set to 600 I upped it a bit). Is there something I can do to ensure they get closed in a given period of time? Joel Fradkin ------=_NextPart_000_005C_01C5AD67.B6BDDCA0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

My install using the new driver (ODBC) seems to have = helped me a great deal.

Unfortunately one of my night jobs uses a dynamic = cube product that does a record set.

I am not certain but I have the feeling it is leaving = the connection open.

After a few days (always at night when the program = runs) I end up running out of connections (was set to 600 I upped it a = bit).

Is there something I can do to ensure they get closed = in a given period of time?

 

Joel Fradkin

 

 

------=_NextPart_000_005C_01C5AD67.B6BDDCA0--