Re: [GENERAL] Threads limit for postmaster
On Fri, Feb 26, 2010 at 17:24, Igor Neyman wrote: > Hello all, > > I found this conversation in mailing lists archives: > > http://archives.postgresql.org/pgsql-general/2007-11/msg01669.php > > OP in this conversation exactly describes my current problem (thread limit > for postmaster running on Windows). > > I'm running 8.2.5, which predates this conversation, and unfortunately in > the nearest future I'm not able to upgrade to newer major releas (8.3 or > 8.4). > But I could upgrade to latest 8.2.15 easily. > In the convesation Magnus H. mentions possible fix "backport" into 8.2. > > I looked through all 8.2 release notes (upto 8.2.15), but couldn't find any > reference to this fix beeing backported into 8.2. > > So, was it or was it not backported into 8.2.5? It has not been backported. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Threads limit for postmaster
Hello all, I found this conversation in mailing lists archives: http://archives.postgresql.org/pgsql-general/2007-11/msg01669.php OP in this conversation exactly describes my current problem (thread limit for postmaster running on Windows). I'm running 8.2.5, which predates this conversation, and unfortunately in the nearest future I'm not able to upgrade to newer major releas (8.3 or 8.4). But I could upgrade to latest 8.2.15 easily. In the convesation Magnus H. mentions possible fix "backport" into 8.2. I looked through all 8.2 release notes (upto 8.2.15), but couldn't find any reference to this fix beeing backported into 8.2. So, was it or was it not backported into 8.2.5? Magnus, sorry for sending this message to you directly (as well as to the list), but it's a really "hot" issue for me. Regards, Igor Neyman
Re: [GENERAL] Threads limit for postmaster
> > > 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/
Re: [GENERAL] Threads limit for postmaster
On 11/30/07, Magnus Hagander <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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
Re: [GENERAL] Threads limit for postmaster
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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] Threads limit for postmaster
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. Regards -- = Guillaume Pungeot - mappy
