Re: Threads limit for postmaster

On 11/30/07, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>
> Guillaume Pungeot wrote:
> > 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?

---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Usama Munir Dar http://linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar