Re: All Production releases of PostgreSQL hung because of

Hi.

I have postgreSQL version 7.2.1 /w cygwin running fine with more than 5
concurrent connections.
Normal 7.2.1 distro. Tested up to 12.

BTW: postgresql-cygwin cannot handle more than 62 concurrent client
connections due to a limitation in windows,
no matter what postgresql.conf says.

Greetings, Joek




-----Oorspronkelijk bericht-----
Van: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org] Namens Reini Urban
Verzonden: zaterdag 11 september 2004 11:43
Aan: cygwin
CC: pgsql-cygwin@postgresql.org
Onderwerp: Re: [CYGWIN] All Production releases of PostgreSQL hung because
of


Jean-Pierre Pelletier schrieb:
> There is currently no production release of PostgreSQL that runs more
> than 5 concurrent sessions
> in Windows because the releases available for Cygwin, 7.4.3 to 7.4.5 are
> built with Cygserver
> which has a bug that have PostgreSQL hung with more than 5 concurrent
> connections.

Hmm, that would explain the crash at the parallel_schedule regression
suite. ipcs showed 5 semaphores, and one shm, when postmaster crashed.
serial tests do work fine. max_connections=100 also works fine.

Do you have any link where this is discussed/analyzed?

> I am planning to ;revert to PostgreSQL 7.1 which is the latest cygwin
> package built with cygipc (instead of cygserver).
>  ;
> It would be nice to have the latest releases of PostgreSQL rebuilt with
> cygipc and available as cygwin packages.

No problem.
If it's really a buggy cygserver I'll do a interim cygipc version. I already
had one, but it clashed with cygserver.

But I really want to try to debug cygserver then.

--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match