Skip site navigation (1) Skip section navigation (2)

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

From: "Nguyen, Lam Thuy" <l7nguyen(at)fcg(dot)com>
To: "Rainer Bauer" <usenet(at)munnin(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:54:36
Message-ID: C3D5057033EDF145B90A99CD9025BFEA07EBBB@hont05.fcg.com (view raw or flat)
Thread:
Lists: 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(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.

In response to

Responses

pgsql-odbc by date

Next:From: Rainer BauerDate: 2008-02-05 23:30:53
Subject: Re: How to open more than 300 connections to postgres database.
Previous:From: Rainer BauerDate: 2008-02-05 22:05:03
Subject: Re: How to open more than 300 connections to postgres database.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group