From: John R Allgood <jallgood@the-allgoods.net>
To: Alvaro Herrera <alvherre@commandprompt.com>
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:40:03 -0400
Message-ID: <46D47A13.3060907@the-allgoods.net> (raw)
In-Reply-To: <20070828191143.GE13868@alvh.no-ip.org>
References: <46D4353F.2040209@the-allgoods.net>
<815.1188324416@sss.pgh.pa.us>
<46D470D8.2030605@the-allgoods.net>
<20070828191143.GE13868@alvh.no-ip.org>
We are using the defaults for these values. Keep in mind we are allowing
between 5-50 max connections per postmaster. Here is an example of our
largest database. It is 7.9GB we allow 50 max connections and the
buffers are set to 16000/125MB. This is our master database and it has a
lot of activity as compared to the other databases. We run VACUUM at
midday VACUUM FULL at night, VACUUM ANALYZE on weekends.
Thanks
Alvaro Herrera wrote:
> 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?
>
>
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: jallgood@the-allgoods.net, alvherre@commandprompt.com, tgl@sss.pgh.pa.us
Subject: Re: How to monitor resources on Linux.
In-Reply-To: <46D47A13.3060907@the-allgoods.net>
* 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