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

Hi Rainer,

There are 3 folders when extracting the download file : ia64,x64,x68.

then i run dheapinst.exe file in x68, i got error : Win32k .sys symbol load eror, correct symbol required.

How i correct it ?

Thanks

________________________________

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

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

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 forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.