Skip site navigation (1) Skip section navigation (2)

Re: oom_killer

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tory M Blue <tmblue(at)gmail(dot)com>
Cc: David Rees <drees76(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: oom_killer
Date: 2011-04-23 19:24:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Apr 22, 2011, at 2:22 PM, Tory M Blue <tmblue(at)gmail(dot)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 see the cache shrink. Not sure what is happening on your system, but typically when it gets down to some minimal size, that's when the swapping starts.


In response to


pgsql-performance by date

Next:From: Robert HaasDate: 2011-04-23 19:34:11
Subject: Re: big distinct clause vs. group by
Previous:From: Robert HaasDate: 2011-04-23 16:11:38
Subject: Re: Shouldn't we have a way to avoid "risky" plans?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group