From: Christopher Browne <cbbrowne@gmail.com>
To: Ravindran G - TLS, Chennai. <ravindran_g@hcl.in>
To: 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 14:28:42 +0000
Message-ID: <d6d6637f0608280728l2dc87be6m573fa31d7974bde6@mail.gmail.com> (raw)
In-Reply-To: <20060828141959.GD27526@alvh.no-ip.org>
References: <012301731C23DE4DBFE035647C68F1CC03BE0092@sindhu.ctd.hcltech.com>
<20060828141959.GD27526@alvh.no-ip.org>
On 8/28/06, Alvaro Herrera <alvherre@commandprompt.com> wrote:
> > Please advise us on how to resolve this ?.
>
> There's no solution short of upgrading.
That's a little too negative. There is at least one alternative,
possibly two...
1. Migrate the database to a Unix platform that does not suffer from
the Cygwin 64 connection restriction. (If running Linux, it may be
necessary to look for an old release, as there were changes to GLIBC
at around the same time as 7.2 that don't play perfectly well with
7.1...)
2. It is *possible* that pg_pool could be usable as a proxy that
limits the number of connections actually used. I'm not sure how well
it'll play with 7.1, mind you...
--
http://www3.sympatico.ca/cbbrowne/linux.html
Oddly enough, this is completely standard behaviour for shells. This
is a roundabout way of saying `don't use combined chains of `&&'s and
`||'s unless you think Gödel's theorem is for sissies'.
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: cbbrowne@gmail.com, ravindran_g@hcl.in, isacnewtona@hcl.in
Subject: Re: Postgre SQL 7.1 cygwin performance issue.
In-Reply-To: <d6d6637f0608280728l2dc87be6m573fa31d7974bde6@mail.gmail.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