Re: PostgreSQL database and other daemons crashing

From: Spencer Anderson <spencer(at)minneapp(dot)com>
To: Vick Khera <vivek(at)khera(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL database and other daemons crashing
Date: 2010-05-20 20:40:50
Message-ID: AANLkTim00F9WNPqqiCbxkMAWdMb4NXxqzwoA0eJx8aQh@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

That may in fact be the cause. I ran, free -lm -s 0.5, to watch my memory
use and saw the output below. My processes didn't die this time when it hit
zero bytes free, but it only lasted for 1 second. Some process must be
occasionally using very excessive memory, and every once in a while, I get
the OOM kill scenario. Guess I need to find that process..

total used free shared buffers cached
Mem: 1024 176 847 0 0 0
Low: 1024 176 847
High: 0 0 0
-/+ buffers/cache: 176 847
Swap: 0 0 0

total used free shared buffers cached
Mem: 1024 176 847 0 0 0
Low: 1024 176 847
High: 0 0 0
-/+ buffers/cache: 176 847
Swap: 0 0 0

total used free shared buffers cached
Mem: 1024 1024 0 0 0 0
Low: 1024 1024 0
High: 0 0 0
-/+ buffers/cache: 1024 0
Swap: 0 0 0

total used free shared buffers cached
Mem: 1024 1024 0 0 0 0
Low: 1024 1024 0
High: 0 0 0
-/+ buffers/cache: 1024 0
Swap: 0 0 0

total used free shared buffers cached
Mem: 1024 176 847 0 0 0
Low: 1024 176 847
High: 0 0 0
-/+ buffers/cache: 176 847
Swap: 0 0 0

total used free shared buffers cached
Mem: 1024 176 847 0 0 0
Low: 1024 176 847
High: 0 0 0
-/+ buffers/cache: 176 847
Swap: 0 0 0

On Thu, May 20, 2010 at 3:29 PM, Vick Khera <vivek(at)khera(dot)org> wrote:

> On Thu, May 20, 2010 at 4:21 PM, Joshua D. Drake <jd(at)commandprompt(dot)com>
> wrote:
> > I wonder if the oom killer is acting up.
> >
>
> that'd be my guess. postfix *never* dies. something external is
> killing your processes.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Spencer Anderson
spencer(at)minneapp(dot)com
(424) 901-1363

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-05-20 21:00:51 Re: PostgreSQL database and other daemons crashing
Previous Message Vick Khera 2010-05-20 20:29:21 Re: PostgreSQL database and other daemons crashing