pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Tory M Blue <tmblue@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: oom_killer
Date: Thu, 21 Apr 2011 08:48:51 -0400
Message-ID: <20110421124851.GC4548@tamriel.snowman.net> (raw)
In-Reply-To: <BANLkTinXiV8ODPP5SwOOwdR5Nstdk98pcw@mail.gmail.com>
References: <BANLkTinXiV8ODPP5SwOOwdR5Nstdk98pcw@mail.gmail.com>

* Tory M Blue (tmblue@gmail.com) wrote:
> 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?

You would really be best off just turning off the oom_killer..  Of
course, you should probably also figure out what process is actually
chewing through your memory to the point that the OOM killer is getting
run.

> 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.

There's probably something else that's trying to grab all the memory and
then tries to use it and PG ends up getting nailed because the kernel
over-attributes memory to it.  You should be looking for that other
process..

	Thanks,

		Stephen

Attachments:

  signature.asc (application/pgp-signature, 197B) download

view thread (30+ messages)  latest in thread

Message-ID: <20110421124851.GC4548@tamriel.snowman.net>
Permalink:  ../20110421124851.GC4548@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20110421124851.GC4548@tamriel.snowman.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sfrost@snowman.net, tmblue@gmail.com
  Subject: Re: oom_killer
  In-Reply-To: <20110421124851.GC4548@tamriel.snowman.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox