Обсуждение: How to open more than 300 connections to postgres database.
Hello, I set max_connecion =300, but it only allows upto 130 connections. I tried to change some para in postgresql.conf file (shared_buffer...), but it was not efficient. I read some document in postgres site said that i should change some para of System V IPC, but how do i change them ? I am using WinXP, SP2, 4GB of GAM Thanks for your help. Lam 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.
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
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.
Hello Lam, Tuesday, February 5, 2008, 11:54:36 PM, you wrote: NLT> There are 3 folders when extracting the download file : ia64,x64,x68. NLT> then i run dheapinst.exe file in x68, i got error : Win32k .sys symbol load eror, correct symbol required. NLT> How i correct it ? You need the correct version of the Win32k.sys symbol file. See section "Additional Information" <http://www.microsoft.com/downloads/details.aspx?familyid=5cfc9b74-97aa-4510-b4b9-b2dc98c8ed8b&displaylang=en#AdditionalInfo> Rainer
Hi Rainer, I installed postgres 8.3.0, it allows over 300 connections. Does postgres 8.2.not support more than 128 connections ? Could you please confirm me ? Tha nks Lam ________________________________ From: Rainer Bauer [mailto:usenet@munnin.com] Sent: Tue 2/5/2008 6:30 PM To: Nguyen, Lam Thuy Cc: pgsql-odbc@postgresql.org Subject: Re[6]: [ODBC] How to open more than 300 connections to postgres database. Hello Lam, Tuesday, February 5, 2008, 11:54:36 PM, you wrote: NLT> There are 3 folders when extracting the download file : ia64,x64,x68. NLT> then i run dheapinst.exe file in x68, i got error : Win32k .sys symbol load eror, correct symbol required. NLT> How i correct it ? You need the correct version of the Win32k.sys symbol file. See section "Additional Information" <http://www.microsoft.com/downloads/details.aspx?familyid=5cfc9b74-97aa-4510-b4b9-b2dc98c8ed8b&displaylang=en#AdditionalInfo> Rainer 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.
Hello Lam, Wednesday, February 6, 2008, 5:29:55 AM, you wrote: NLT> The attachment includes : NLT> - psqlodbc log NLT> - Desktop heap info when i got error. NLT> - postgressql.conf Could you attach the files directly. I only see one file called Winmail.dat [20kb] and cannot open it. NLT> I installed postgres 8.3.0, it allows over 300 connections. NLT> Does postgres 8.2.not support more than 128 connections ? NLT> Could you please confirm me ? Yes, the "Desktop Heap Problem" was solved in Postgres 8.3. Rainer
Hi Rainer But Postgres 8.3 has just been release few days, is it stable for using ? Do you have any solutions for 8.2 ? because i am using 8.2, it will be hard for me if i change to 8.3. Could you review these files i sent to you in the previous mail, and give me some adives. Thanks Lamsta ________________________________ From: Rainer Bauer [mailto:usenet@munnin.com] Sent: Wed 2/6/2008 5:03 AM To: Nguyen, Lam Thuy Cc: pgsql-odbc@postgresql.org Subject: Re[6]: [ODBC] How to open more than 300 connections to postgres database. Hello Lam, Wednesday, February 6, 2008, 5:29:55 AM, you wrote: NLT> The attachment includes : NLT> - psqlodbc log NLT> - Desktop heap info when i got error. NLT> - postgressql.conf Could you attach the files directly. I only see one file called Winmail.dat [20kb] and cannot open it. NLT> I installed postgres 8.3.0, it allows over 300 connections. NLT> Does postgres 8.2.not support more than 128 connections ? NLT> Could you please confirm me ? Yes, the "Desktop Heap Problem" was solved in Postgres 8.3. Rainer 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.
Hello Lam, Wednesday, February 6, 2008, 3:07:04 PM, you wrote: NLT> Here is the attatchment Sorry, same as last time: only a winmail.dat file. Maybe you could upload the files to a public server? Rainer
Nguyen, Lam Thuy wrote: > Hi Rainer > > But Postgres 8.3 has just been release few days, is it stable for using ? > > Do you have any solutions for 8.2 ? because i am using 8.2, it will be hard for me if i change to 8.3. The driver's version isn't so tightly related to the server's version and you can live with the 8.3.xxxx driver and the 8.2 server without any problem. The driver's own limitation about max connections (128) was removed at 8.2.0402 version though I'm not sure if the change guarantees >= 300 connections. You can download various version of psqlODBC drivers from http://www.postgresql.org/ftp/odbc/versions/ in Windows Installer, merge module, source and basic zip file formats.
Hello Hiroshi, Wednesday, February 6, 2008, 6:46:39 PM, you wrote: HI> The driver's own limitation about max connections (128) HI> was removed at 8.2.0402 version though I'm not sure if the change guarantees >>= 300 connections. Ah, that explains why I couldn't see any error here. I was looking at the source code of 8.2.0402. Rainer
You mean postgres 8.2.0402 does not support more than 128 connection ? Could you please confirm me clearly so that i can find the best solution i should change or not. Thanks ________________________________ From: pgsql-odbc-owner@postgresql.org on behalf of Rainer Bauer Sent: Wed 2/6/2008 2:10 PM To: Hiroshi Inoue Cc: pgsql-odbc@postgresql.org Subject: Re: [ODBC] How to open more than 300 connections to postgres database. Hello Hiroshi, Wednesday, February 6, 2008, 6:46:39 PM, you wrote: HI> The driver's own limitation about max connections (128) HI> was removed at 8.2.0402 version though I'm not sure if the change guarantees >>= 300 connections. Ah, that explains why I couldn't see any error here. I was looking at the source code of 8.2.0402. Rainer ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster 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.
Hello Lam, Wednesday, February 6, 2008, 8:14:01 PM, you wrote: NLT> You mean postgres 8.2.0402 does not support more than 128 connection ? NLT> Could you please confirm me clearly so that i can find the best solution i should change or not. No, Postgres 8.2 does support more than 128 connections (provided that you have increased the desktop heap accordingly). However, you will need at least psqlODBC 8.2.0402. Since the driver is backward compatible, you should use the latest driver available (i.e. psqlODBC 8.3.0100). You can find all driver versions here: <http://www.postgresql.org/ftp/odbc/versions/msi/> Rainer
Nguyen, Lam Thuy wrote: > You mean postgres 8.2.0402 does not support more than 128 connection ? 8.2.0402 is OK though 8.2.0401 isn't good. Please note the version is the driver's one and isn't related to the server's version. Most client packages have their own development cycle and you can install the packages (psqlodbc driver of course) separately. Probably you can find neither 8.2.0402 nor 8.2.0401 version of the psqlodbc driver and so plaese use the 8.3.0100 or 8.2.0500 version. regards, Hiroshi Inoue