X-Original-To: pgsql-hackers-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C8BD69FB28C for ; Thu, 10 Aug 2006 13:25:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 32745-02 for ; Thu, 10 Aug 2006 13:25:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.203]) by postgresql.org (Postfix) with ESMTP id 37D219FB1E9 for ; Thu, 10 Aug 2006 13:25:28 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id z31so77506nzd for ; Thu, 10 Aug 2006 09:25:27 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=oxfNUp2hDS16HjZF42BpOydPkzVS9/ggKtnwlac8pJPr81XL1quCH+V76ca7s+Kc+p2YRYE26IVED4x8kpnZf1cuVSdBOrxUfs0FfyRhMARHBHROPiGhlNjHUG1WPJIyotwwQu1r5ADCMrC8fvmW95h//iXh26Rre08EBeK6UyQ= Received: by 10.65.186.18 with SMTP id n18mr2639383qbp; Thu, 10 Aug 2006 09:25:27 -0700 (PDT) Received: by 10.65.139.10 with HTTP; Thu, 10 Aug 2006 09:25:27 -0700 (PDT) Message-ID: Date: Thu, 10 Aug 2006 12:25:27 -0400 From: "Merlin Moncure" To: "Tom Lane" Subject: Re: Win32 max connections bug (causing crashes) Cc: "William ZHANG" , pgsql-hackers@postgresql.org In-Reply-To: <16261.1155226201@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <44DA6CF6.8020201@commandprompt.com> <44DAAA38.2070300@commandprompt.com> <44DAAAC0.7010303@commandprompt.com> <16261.1155226201@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.374 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/719 X-Sequence-Number: 88212 On 8/10/06, Tom Lane wrote: > "William ZHANG" 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