Re: Threads limit for postmaster
От | Magnus Hagander |
---|---|
Тема | Re: Threads limit for postmaster |
Дата | |
Msg-id | 200711301036120000@195621812 обсуждение исходный текст |
Ответ на | Threads limit for postmaster ("Guillaume Pungeot" <gpungeot@gmail.com>) |
Список | 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 по дате отправления: