Search Postgresql Archives

Re: Threads limit for postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> > > 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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux