Re: How to monitor resources on Linux.

Поиск
Список
Период
Сортировка
От John R Allgood
Тема Re: How to monitor resources on Linux.
Дата
Msg-id 46D47A13.3060907@the-allgoods.net
обсуждение исходный текст
Ответ на Re: How to monitor resources on Linux.  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: How to monitor resources on Linux.  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-admin
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?
 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to import CSV file?
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: How to monitor resources on Linux.