Re: How to open more than 300 connections to postgres database. - Mailing list pgsql-odbc

From Nguyen, Lam Thuy
Subject Re: How to open more than 300 connections to postgres database.
Date
Msg-id C3D5057033EDF145B90A99CD9025BFEA07EBBB@hont05.fcg.com
Whole thread Raw
In response to How to open more than 300 connections to postgres database.  ("Nguyen, Lam Thuy" <l7nguyen@fcg.com>)
Responses Re: How to open more than 300 connections to postgres database.
List pgsql-odbc
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@munnin.com]
Sent: Tue 2/5/2008 5:05 PM
To: Nguyen, Lam Thuy
Cc: pgsql-odbc@postgresql.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@munnin.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
theintended 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
contactthe sender and delete all copies. 



--
Best regards,
 Rainer                            mailto:usenet@munnin.com




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

pgsql-odbc by date:

Previous
From: Rainer Bauer
Date:
Subject: Re: How to open more than 300 connections to postgres database.
Next
From: Rainer Bauer
Date:
Subject: Re: How to open more than 300 connections to postgres database.