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

[Rainer Bauer <usenet(at)munnin(dot)com>]

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