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 Haas||Date: 2011-04-23 19:34:11|
|Subject: Re: big distinct clause vs. group by|
|Previous:||From: Robert Haas||Date: 2011-04-23 16:11:38|
|Subject: Re: Shouldn't we have a way to avoid "risky" plans?|