From: Greg Smith <greg@2ndquadrant.com>
To: Andy Colson <andy@squeakycode.net>
Cc: Rob <rclemley@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: System overload / context switching / oom, 8.3
Date: Wed, 03 Feb 2010 02:48:19 -0500
Message-ID: <4B692A43.1070007@2ndquadrant.com> (raw)
In-Reply-To: <4B688F76.9010002@squeakycode.net>
References: <4B6878DF.3000004@yahoo.com>
<4B688F76.9010002@squeakycode.net>
Andy Colson wrote:
> The oom-killer is kicking in, at some point, so somebody is using too
> much ram. There should be messages or logs or something, right?
> (I've never enabled the oom stuff so dont know much about it). But
> the log messages might be helpful.
They probably won't be. The information logged about what the OOM
killer decided to kill is rarely sufficient to tell anything interesting
about the true cause in a PostgreSQL context--only really helpful if
you've got some memory hog process it decided to kill. In this case,
seems to be a simple situation: way too many connections for the
work_mem setting used for a 8GB server to support. I'd take a look at
the system using "top -c" as well, in good times and bad if possible,
just to see if any weird memory use is showing up somewhere, perhaps
even outside the database.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
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: greg@2ndquadrant.com, andy@squeakycode.net, rclemley@yahoo.com
Subject: Re: System overload / context switching / oom, 8.3
In-Reply-To: <4B692A43.1070007@2ndquadrant.com>
* 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