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

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 (view raw or flat)
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

pgsql-odbc by date

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

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