Re: Threads limit for postmaster - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Threads limit for postmaster
Date
Msg-id 200711301036120000@195621812
Whole thread Raw
In response to Threads limit for postmaster  ("Guillaume Pungeot" <gpungeot@gmail.com>)
List pgsql-general
> > > Hi,
> > > I have a problem when a lot of connexions are opened on postgresql.
> > >
> > > When 243 threads have been created by postmaster, the next CreateThread
> > > fails and the following error is written in pglogs : "FATAL:  could not
> > > create sigchld waiter thread: error code 8".
> > >
> > > I need to open more than 300 connexions on my server.
> > > Is there anyone to help me ?
> > >
> > > OS : windows 2003 server x64 edition.
> >
> > This is a known limitation and will be fixed in 8.3. We'll consider
> > backporting this to 8.2 once it has been proven in the field. So if you
> > can, please download the latest beta of 8.3 and give that a try.
> >
> > //Magnus
>
>
>
> Would increasing the Desktop shared memory size, as described in another
> thread , by changing a registry setting would help his case?
>

I don't think so. This looks like the running out of address-space in the postmaster problem, which is a different one.

/Magnus


pgsql-general by date:

Previous
From: "Usama Dar"
Date:
Subject: Re: Postgres High Availablity Solution needed for hot-standby and load balancing
Next
From: Glyn Astill
Date:
Subject: invalid byte sequence for encoding "UTF8"