Re: How to open more than 300 connections to postgres database.

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: "Nguyen, Lam Thuy" <l7nguyen(at)fcg(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: How to open more than 300 connections to postgres database.
Date: 2008-02-05 22:05:03
Message-ID: 123212648.20080205230503@munnin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello Lam,

Tuesday, February 5, 2008, 10:49:46 PM, you wrote:

NLT> RB> These changes require a reboot of windows to become effective. Did you
NLT> RB> do that?

NLT> yes, of course.

NLT> I tried many times, could you please help me.

What we have to find out is whether it's the desktop heap's fault or a
bug in the driver.

There are two things you can do:

1) Download and install the "Desktop Heap Monitor" and watch the
desktop heap usage when your 128th connection has been established:
<http://www.microsoft.com/downloads/details.aspx?familyid=5cfc9b74-97aa-4510-b4b9-b2dc98c8ed8b&displaylang=en>
2) Enable debugging output in the ODBC driver and post the mylog
output here.

Rainer

NLT> ________________________________

NLT> From: Rainer Bauer [mailto:usenet(at)munnin(dot)com]
NLT> Sent: Tue 2/5/2008 4:49 PM
NLT> To: Nguyen, Lam Thuy
NLT> Subject: Re[2]: [ODBC] How to open more than 300 connections to postgres database.

NLT> Hello Lam,

NLT>> I did but it i is still not efficient.
NLT>> I try to increate or decrease the third SharedSection value, the second ShareSection value ,

NLT> You only have to increase the third value.

NLT>> but the size of each connection is still no change with 6200kb.

NLT> These changes require a reboot of windows to become effective. Did you
NLT> do that?

NLT> Rainer

NLT> This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient. Any review, reliance, or distribution by others or
NLT> forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.

--
Best regards,
Rainer mailto:usenet(at)munnin(dot)com

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Nguyen, Lam Thuy 2008-02-05 22:54:36 Re: How to open more than 300 connections to postgres database.
Previous Message Nguyen, Lam Thuy 2008-02-05 18:34:34 Re: Can't open more than 128 connections