Re: How to monitor resources on Linux.

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

John R Allgood wrote:
> Hey Tom
>
>    Thanks for responding. This issue came around because of a situation 
> yesterday with processes being killed off by the kernel.  I believe my co 
> worker Geof Myers sent a post yesterday and the response was to adjust the 
> vm.commit_memory=2. Several time throughout the day we see memory usage 
> peak and then it will go down. We have multiple postmasters running for 
> each of our division so that I we have a problem with a database it only 
> affects that one. It make it diffucult to tune a system with this many 
> postmasters running. Each database is tuned according to need. We allow 
> anywhere between 5-50 max connections. So what I am looking for is?  

Any of work_mem or maintenance_worm_mem set too high can cause excessive
memory usage.  What do you have these set to?

-- 
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"World domination is proceeding according to plan"        (Andrew Morton)