Re: Postgre SQL 7.1 cygwin performance issue. - Mailing list pgsql-performance

From Christopher Browne
Subject Re: Postgre SQL 7.1 cygwin performance issue.
Date
Msg-id d6d6637f0608280728l2dc87be6m573fa31d7974bde6@mail.gmail.com
Whole thread Raw
In response to Re: Postgre SQL 7.1 cygwin performance issue.  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Postgre SQL 7.1 cygwin performance issue.
List pgsql-performance
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'.

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Postgre SQL 7.1 cygwin performance issue.
Next
From: Michal Taborsky - Internet Mall
Date:
Subject: Identifying bloated tables