Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id C5D901337B68 for ; Fri, 22 Apr 2011 14:18:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 18026-07 for ; Fri, 22 Apr 2011 17:18:38 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iy0-f174.google.com (mail-iy0-f174.google.com [209.85.210.174]) by mail.postgresql.org (Postfix) with ESMTP id C3B9C1337B47 for ; Fri, 22 Apr 2011 14:18:37 -0300 (ADT) Received: by iyb14 with SMTP id 14so588336iyb.19 for ; Fri, 22 Apr 2011 10:18:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=iB0hMdNV9di+WBu+dc3UYQHShEy1YeuFlJlEuSm13Fs=; b=QQZTMGcYFpzT/qQqbVrLvEDwp98Sw7VbqGGSwpcS9KoTZucJA1ITlON7jEcQG2ryYA CEjVzOEZve2ti+8i5jGcZZMtTYGDPVrS3H5r835+xx8PUgHDatJcez2TTQgulvG/iDgg KkI9OPmXEFJttQ9gr3Y4Ym8ILwLljy2MgyKRU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=ku1FDtquiXPbdJ+KSZ2kwXFz6N9sfhf64yyCPNwy2rYZbPF/kK4rWf0G7RNgCreSoB uXWU8oEsPgs8WvPEGgGCqWFGnvZOmPUVp0HBsniSpYoqHoXLuaRtiPNwhULTVZOJNNZE fMicDjbn2NQi9pUtaieijB5IqhRAEpa+j8t7w= MIME-Version: 1.0 Received: by 10.231.216.168 with SMTP id hi40mr913789ibb.196.1303492716958; Fri, 22 Apr 2011 10:18:36 -0700 (PDT) Received: by 10.231.147.145 with HTTP; Fri, 22 Apr 2011 10:18:36 -0700 (PDT) In-Reply-To: References: Date: Fri, 22 Apr 2011 10:18:36 -0700 Message-ID: Subject: Re: oom_killer From: Tory M Blue To: =?ISO-8859-1?Q?C=E9dric_Villemain?= Cc: Merlin Moncure , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201104/322 X-Sequence-Number: 43384 On Fri, Apr 22, 2011 at 9:46 AM, C=E9dric Villemain wrote: > 2011/4/22 C=E9dric Villemain : >> Are you sure it is a PAE kernel ? You look limited to 4GB. >> >> I don't know atm if overcommit_ratio=3D0 has a special meaning, else I >> would suggest to update it to something like 40% (the default), but > > default being 50 ... > >> 60% should still be safe (60% of 32GB + 5GB) 2.6.32.23-170.fc12.i686.PAE , so it says. Okay so instead of dropping to 2-0 with the overcommit and ratio settings, I should look at matching the ratio more to what I actually have in swap? Sorry but knee jerk reaction when I got hit by the oom_killer twice. Tory