We are using PostgreSQL 7.1 cygwin installed on Windows 2000.
We understand that the maximum connections that can be set is 64 in
Postgresql 7.1 version.
But our application is installed in 8 / 10 PC or more than that and it opens
multiple connections and it exceeds 64.
Because of this the subsequent connections are failed to connect with DB
Please advise us on how to resolve this ?.
Migrating to 8.1 may not be possible at this point of time due to some
From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
Sent: Monday, August 28, 2006 7:02 PM
To: Ravindran G - TLS, Chennai.
Subject: Re: [PERFORM] Postgre SQL 7.1 cygwin performance issue.
Ravindran G - TLS, Chennai. wrote:
> I would like to talk to one of the org member in postgre about this issue.
> This is critical for us. Please help.
> It will be great, if you could provide your contact number to discuss on
Sure, we're happy to help. You can contact several "org members" via
this mailing list. What's your problem exactly? If you're finding that
the 7.1 cygwin version is too slow, please consider migrating some
something more recent. 8.1 runs natively on Windows, no Cygwin required.
It's much faster and doesn't have that limitation on the number of
Please note that the name is "PostgreSQL" and is usually shortened to
"Postgres". It's never "postgre".
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
The contents of this e-mail and any attachment(s) are confidential and intended for the
named recipient(s) only. It shall not attach any liability on the originator or HCL or its
affiliates. Any views or opinions presented in this email are solely those of the author and
may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or publication of this
message without the prior written consent of the author of this e-mail is strictly
prohibited. If you have received this email in error please delete it and notify the sender
immediately. Before opening any mail and attachments please check them for viruses and
pgsql-performance by date
|Next:||From: Christopher Browne||Date: 2006-08-28 14:17:51|
|Subject: Re: Postgre SQL 7.1 cygwin performance issue.|
|Previous:||From: Guillaume Cottenceau||Date: 2006-08-28 13:47:42|
|Subject: Re: perf pb solved only after pg_dump and restore|