Re: PostgreSQL database and other daemons crashing - Mailing list pgsql-general

From Spencer Anderson
Subject Re: PostgreSQL database and other daemons crashing
Date
Msg-id AANLkTim00F9WNPqqiCbxkMAWdMb4NXxqzwoA0eJx8aQh@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL database and other daemons crashing  (Vick Khera <vivek@khera.org>)
List 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@khera.org> wrote:
On Thu, May 20, 2010 at 4:21 PM, Joshua D. Drake <jd@commandprompt.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Spencer Anderson
spencer@minneapp.com
(424) 901-1363

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: PostgreSQL database and other daemons crashing
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL database and other daemons crashing