From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-performance@postgresql.org, "Isac Newton A - TLS, Chennai." <isacnewtona@hcl.in>
Subject: Re: Postgre SQL 7.1 cygwin performance issue.
Date: Mon, 28 Aug 2006 09:56:46 -0500
Message-ID: <1156777006.3932.11.camel@state.g2switchworks.com> (raw)
In-Reply-To: <012301731C23DE4DBFE035647C68F1CC03BE0092@sindhu.ctd.hcltech.com>
References: <012301731C23DE4DBFE035647C68F1CC03BE0092@sindhu.ctd.hcltech.com>
On Mon, 2006-08-28 at 09:00, Ravindran G - TLS, Chennai. wrote:
> 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 ?.
As someone else mentioned, pg_pool might help here. But you're kind of
fighting an uphill battle here. I'm guessing that your effort will be
better spent on upgrading your db server than on trying to patch up the
system you have.
Is there any chance of changing your client app so it doesn't open so
many connections? That would seem the easiest fix of all, if you have
access to that code.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: smarlowe@g2switchworks.com, ravindran_g@hcl.in, alvherre@commandprompt.com, isacnewtona@hcl.in
Subject: Re: Postgre SQL 7.1 cygwin performance issue.
In-Reply-To: <1156777006.3932.11.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox