Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 1D5B81337B82 for ; Thu, 21 Apr 2011 09:37:21 -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 03270-01 for ; Thu, 21 Apr 2011 12:37:12 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id D34C9133798E for ; Thu, 21 Apr 2011 09:37:11 -0300 (ADT) Received: by wya21 with SMTP id 21so1387543wya.19 for ; Thu, 21 Apr 2011 05:37:11 -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:content-type; bh=lmaI7wGVeP5VK7JTlcKOqiXX3dzCsc57/2p7E/AHzuE=; b=MruCHELp5HY+SEDJ7x9sMl5qqAgQIFdhothyBAHCuz0flYAQmyFHxtUb1R8GJy5FQy OV3BPa7xYyJV3Qq1Jta7Qse/1+1WsAOmttqHahzRx1k6Muld3kdqnTbsKxCIokuLVcPf q0Xuq4T1BlRgxovLniBN9PiDKQDSdUfddZKI8= 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 :content-type; b=odq5SaFfgYPbaipPcuGDnzdLTMNhUimwPrZpJkpl6VmBTJDGXWPHR2FlVDmPwPyw6m DhprHkl5/Dxf0I0kIyaunFgVsBXH74upQNqSQPYpYi8PY3+XExHWtVA58MPyuavm5/El ltg6czcziCznC2caPZhjk0DTe7X/ZQo/+W/R4= MIME-Version: 1.0 Received: by 10.216.240.12 with SMTP id d12mr3632293wer.8.1303389431488; Thu, 21 Apr 2011 05:37:11 -0700 (PDT) Received: by 10.216.81.135 with HTTP; Thu, 21 Apr 2011 05:37:11 -0700 (PDT) In-Reply-To: References: Date: Thu, 21 Apr 2011 14:37:11 +0200 Message-ID: Subject: Re: oom_killer From: yoshi watanabe To: pgsql-performance@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.335 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201104/298 X-Sequence-Number: 43360 Funny concidence, I was just reading up a blog post on postgres an OOM killer. http://gentooexperimental.org/~patrick/weblog/archives/2011-04.html#e2011-04-20T21_58_37.txt Hope this helps. 2011/4/21 Tory M Blue : > Is there anyone that could help me understand why all of a sudden with > no noticeable change in data, no change in hardware, no change in OS, > I'm seeing postmaster getting killed by oom_killer? > > The dmesg shows that swap has not been touched free and total are the > same, so this system is not running out of total memory per say. > > I keep thinking it's something to do with lowmem vs highmem 32bit vs > 64 bit, but again no changes and I'm getting hit nightly on 2 > different servers (running slon, so switched over and same thing, even > disabled memory over commit and still got nailed. > > Is there anyone familiar with this or could take a look at the dmesg > output (off list) and decipher it for me? > > this is a Fedora 12 system, 2.6.32.23-170. I've been reading and > appears this is yet another fedora bug, but so far I have not found > any concrete evidence on how to fix it. > > Fedora 12 > 32gig memory, 8 proc > postgres 8.4.4, slony 1.20 > 5 gigs of swap (never hit it!) > > Thanks > Tory > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >