pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: John R Allgood <jallgood@the-allgoods.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to monitor resources on Linux.
Date: Tue, 28 Aug 2007 15:11:44 -0400
Message-ID: <20070828191143.GE13868@alvh.no-ip.org> (raw)
In-Reply-To: <46D470D8.2030605@the-allgoods.net>
References: <46D4353F.2040209@the-allgoods.net>
	<815.1188324416@sss.pgh.pa.us>
	<46D470D8.2030605@the-allgoods.net>

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)



view thread (28+ messages)  latest in thread

Message-ID: <20070828191143.GE13868@alvh.no-ip.org>
Permalink:  ../20070828191143.GE13868@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20070828191143.GE13868@alvh.no-ip.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alvherre@commandprompt.com, jallgood@the-allgoods.net, tgl@sss.pgh.pa.us
  Subject: Re: How to monitor resources on Linux.
  In-Reply-To: <20070828191143.GE13868@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox