Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 65D899FB20F for ; Mon, 27 Nov 2006 09:20:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 83539-06 for ; Mon, 27 Nov 2006 09:20:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by postgresql.org (Postfix) with ESMTP id 281C19FB1F8 for ; Mon, 27 Nov 2006 09:20:44 -0400 (AST) Received: from osgiliath.mathom.us ([71.246.251.8]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0J9E00I5C521MC2B@vms046.mailsrvcs.net> for pgsql-performance@postgresql.org; Mon, 27 Nov 2006 07:20:25 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id DC5506E8D1 for ; Mon, 27 Nov 2006 08:20:23 -0500 (EST) Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath.home.mathom.us [127.0.0.1]) (amavisd-new, port 10024) with LMTP id w+gyvy0+JEra for ; Mon, 27 Nov 2006 08:20:22 -0500 (EST) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 5B5CE70893; Mon, 27 Nov 2006 08:20:22 -0500 (EST) Date: Mon, 27 Nov 2006 08:20:22 -0500 From: Michael Stone Subject: Re: Postgres server crash In-reply-to: <20061126234101.GG39519@nasby.net> To: pgsql-performance@postgresql.org Mail-followup-to: pgsql-performance@postgresql.org Message-id: <20061127132019.GA27186@mathom.us> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline X-Virus-Scanned: Debian amavisd-new at mathom.us X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 References: <19583.1163700841@sss.pgh.pa.us> <20061126234101.GG39519@nasby.net> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/242 X-Sequence-Number: 22012 On Sun, Nov 26, 2006 at 05:41:02PM -0600, Jim C. Nasby wrote: >What's interesting is that apparently FreeBSD also has overcommit (and >IIRC no way to disable it), yet I never hear people going off on OOM >kills in FreeBSD. Could just be that nobody is using FreeBSD. Seriously, though, there are so many linux installations out there that you're statistically more likely to see corner cases. FWIW, I know a whole lotta linux machines that have never had OOM-killer problems. Remember, though, that anecodotal evidence isn't. Mike Stone