Postgres Pro
Downloads
Home   >   mailing lists

Thread: Threads limit for postmaster

Threads limit for postmaster

From
"Guillaume Pungeot"
Date:
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.

Regards

--
=========
Guillaume Pungeot - mappy

Re: Threads limit for postmaster

From
Magnus Hagander
Date:
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

Re: Threads limit for postmaster

From
"Usama Dar"
Date:


On 11/30/07, Magnus Hagander <magnus@hagander.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@postgresql.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

Re: Threads limit for postmaster

From
"Magnus Hagander"
Date:
> > > 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