Re: Win32 max connections bug (causing crashes) - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Win32 max connections bug (causing crashes)
Date
Msg-id b42b73150608100925u67d6b5e7p9083d9769f8d57c8@mail.gmail.com
Whole thread Raw
In response to Re: Win32 max connections bug (causing crashes)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Win32 max connections bug (causing crashes)
List pgsql-hackers
On 8/10/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "William ZHANG" <uniware@zedware.org> writes:
> > Maybe this article can help:
> > Windows and the ClearCase process limit: Understanding the desktop heap
> > http://www-128.ibm.com/developerworks/rational/library/05/1220_marechal/
>
> So the short answer is "get a real operating system"?

changing a registry setting is not terrible in and of itself, akin to
manually manipluating procfs, but the behavior is in a failure
condition is. other than that, no comment. personally all my servers
are running mixture of gentoo and centos and i'm moving my desktop to
mac os x.

> I'm not sure I believe that article though, since it claims that the
> default maximum number of noninteractive processes is only 79.
> I thought from what was said upthread that we could get up to a couple
> hundred before seeing a problem.

that would depend on various factors, especially exactly how many
resources the ibm server software ate up for each connection. pg seems
to be leaner and meaner fwiw.  anyways, i confirmed the fix.

merlin


pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: libpq Describe Extension [WAS: Bytea and perl]
Next
From: Tom Lane
Date:
Subject: Re: libpq Describe Extension [WAS: Bytea and perl]