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)