From: | "Usama Dar" <munir(dot)usama(at)gmail(dot)com> |
---|---|
To: | "Magnus Hagander" <magnus(at)hagander(dot)net> |
Cc: | "Guillaume Pungeot" <gpungeot(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Threads limit for postmaster |
Date: | 2007-11-30 09:29:54 |
Message-ID: | ff0e67090711300129v66914554i6f71c46437e798fb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Usama Dar | 2007-11-30 09:34:40 | Re: Postgres High Availablity Solution needed for hot-standby and load balancing |
Previous Message | Usama Dar | 2007-11-30 09:26:57 | Re: can't createdb with my new user |