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

Re: Postgre SQL 7.1 cygwin performance issue.

From: "Ravindran G - TLS, Chennai(dot)" <ravindran_g(at)hcl(dot)in>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>,"Isac Newton A - TLS, Chennai(dot)" <isacnewtona(at)hcl(dot)in>
Subject: Re: Postgre SQL 7.1 cygwin performance issue.
Date: 2006-08-28 14:00:44
Message-ID: 012301731C23DE4DBFE035647C68F1CC03BE0092@sindhu.ctd.hcltech.com (view raw or flat)
Thread:
Lists: pgsql-performance
Thanks Alvaro.

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
from application.

Please advise us on how to resolve this ?. 

--

Migrating to 8.1 may not be possible at this point of time due to some
reasons. 

Regards, Ravi


-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
Sent: Monday, August 28, 2006 7:02 PM
To: Ravindran G - TLS, Chennai.
Cc: pgsql-performance(at)postgresql(dot)org
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
> this. 

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
connections.

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.
DISCLAIMER 
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 

defect.

Responses

pgsql-performance by date

Next:From: Christopher BrowneDate: 2006-08-28 14:17:51
Subject: Re: Postgre SQL 7.1 cygwin performance issue.
Previous:From: Guillaume CottenceauDate: 2006-08-28 13:47:42
Subject: Re: perf pb solved only after pg_dump and restore

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