Adding more memory = hugh cpu load

Поиск
Список
Период
Сортировка
От alexandre - aldeia digital
Тема Adding more memory = hugh cpu load
Дата
Msg-id 4E92F294.9010405@gmail.com
обсуждение исходный текст
Ответы Re: Adding more memory = hugh cpu load  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Adding more memory = hugh cpu load  (Shaun Thomas <sthomas@peak6.com>)
Re: Adding more memory = hugh cpu load  (Luca Tettamanti <kronos.it@gmail.com>)
Список pgsql-performance
Hi,

Yesterday, a customer increased the server memory from 16GB to 48GB.

Today, the load of the server hit 40 ~ 50 points.
With 16 GB, the load not surpasses 5 ~ 8 points.

The only parameter that I changed is effective_cache_size (from 14 GB to
40GB) and shared_buffers (from 1 GB to 5 GB). Setting the values back
does not take any effect.

This server use CentOS 5.5 (2.6.18-194.3.1.el5.centos.plus - X86_64).
Should I change some vm parameters to this specific kernel ?

Thanks for any help.

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

Предыдущее
От: Leonardo Francalanci
Дата:
Сообщение: Re: : Performance Improvement Strategy
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Adding more memory = hugh cpu load