Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
Дата
Msg-id 5614AF06.1050502@agliodbs.com
обсуждение исходный текст
Ответ на shared-buffers set to 24GB but the RAM only use 4-5 GB average  (FattahRozzaq <ssoorruu@gmail.com>)
Список pgsql-performance
On 10/06/2015 02:33 AM, FattahRozzaq wrote:
> @Merlin Moncure, I got the calculation using pg_tune. And I modified
> the shared_buffers=24GB and the effective_cache_size=64GB

I really need to get Greg to take down pg_tune. It's way out of date.

Probably, I should replace it.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


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

Предыдущее
От: ajaykbs
Дата:
Сообщение: Re: Multi processor server overloads occationally with system process while running postgresql-9.4
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4