Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id E7A259FA5CE for ; Tue, 21 Nov 2006 10:08:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 29112-02-6 for ; Tue, 21 Nov 2006 10:08:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 53BEE9FB281 for ; Tue, 21 Nov 2006 10:06:55 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186]) by svr4.postgresql.org (Postfix) with ESMTP id 510745B043D for ; Tue, 21 Nov 2006 13:23:01 +0000 (GMT) Received: from kingfisher.intern.logix-tt.com (84-72-188-217.dclient.hispeed.ch [84.72.188.217]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id ACD4D64BB7; Tue, 21 Nov 2006 14:25:44 +0100 (CET) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 40C571865C802; Tue, 21 Nov 2006 14:22:41 +0100 (CET) Message-ID: <4562FDA0.6060602@logix-tt.com> Date: Tue, 21 Nov 2006 14:22:40 +0100 From: Markus Schaber Organization: Logical Tracking and Tracing International AG, Switzerland User-Agent: Thunderbird 1.5.0.7 (X11/20060927) MIME-Version: 1.0 To: Richard Troy Cc: pgsql-performance@postgresql.org Subject: Re: Postgres server crash References: In-Reply-To: X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/170 X-Sequence-Number: 21940 Hi, Richard, Richard Troy wrote: > The reason I spent a couple of hours looking for what I could learn on > this is that I've been absolutely beside myself on this "extremely > unfortunate" "feature." I had a badly behaving app (but didn't know which > app it was), so Linux would kill lots of things, like, oh, say, inetd. Actually, AFAICT, Linux tries to kill the process(es) that use the most memory ressources first. Without overcommitment, the OOM killer won't kick in, and as long as the hoggy applications don't actually exit when malloc fails, they will just stay around, sitting on their memory. > Good luck sshing into the box. SSH'ing into the box will even get worse without overcommitment. When the machine is stuck, the sshd that tries to spawn its child will get the out of memory signal, and you won't be able to log in. HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org