Re: oom_killer - Mailing list pgsql-performance

From Robert Haas
Subject Re: oom_killer
Date
Msg-id A245910A-7980-42D1-B2B5-EEEDCF173CAA@gmail.com
Whole thread Raw
In response to Re: oom_killer  (Tory M Blue <tmblue@gmail.com>)
Responses Re: oom_killer  (Tory M Blue <tmblue@gmail.com>)
List pgsql-performance
On Apr 22, 2011, at 2:22 PM, Tory M Blue <tmblue@gmail.com> wrote:
> Thanks David and I have and in fact I do see spikes that would cause
> my system to run out of memory, but one thing I'm struggling with is
> my system always runs at the limit. It's the nature of linux to take
> all the memory and manage it.

One thing to watch is the size of the filesystem cache. Generally as the system comes under memory pressure you will
seethe cache shrink. Not sure what is happening on your system, but typically when it gets down to some minimal size,
that'swhen the swapping starts. 

...Robert

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Shouldn't we have a way to avoid "risky" plans?
Next
From: Robert Haas
Date:
Subject: Re: big distinct clause vs. group by