| From: | "Magnus Hagander" <magnus(at)hagander(dot)net> |
|---|---|
| To: | "Usama Dar" <munir(dot)usama(at)gmail(dot)com> |
| 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:36:11 |
| Message-ID: | 200711301036120000@195621812 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Glyn Astill | 2007-11-30 09:44:36 | invalid byte sequence for encoding "UTF8" |
| Previous Message | Usama Dar | 2007-11-30 09:34:40 | Re: Postgres High Availablity Solution needed for hot-standby and load balancing |