Re: Threads limit for postmaster

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Help needed optimizing query
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: can't createdb with my new user