Re: [PERFORM] Very poor read performance, query independent

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема Re: [PERFORM] Very poor read performance, query independent
Дата
Msg-id DM5PR07MB281020250424625EAAFDD77ADAAF0@DM5PR07MB2810.namprd07.prod.outlook.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Very poor read performance, query independent  (Charles Nadeau <charles.nadeau@gmail.com>)
Список pgsql-performance
Дерево обсуждения

 

From: Charles Nadeau [mailto:charles.nadeau@gmail.com]
Sent: Wednesday, July 12, 2017 3:21 AM
To: Igor Neyman <ineyman@perceptron.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Very poor read performance, query independent

 

Igor,

 

I set shared_buffers to 24 GB and effective_cache_size to 64GB and I can see that the queries are faster due to the fact that the index are used more often. Knowing I have 72GB of RAM and the server is exclusively dedicated to Postgresql, what could be the maximum value for effective_cache?

Thanks!

 

Charles

 

64GB for effective_cache_size should be good enough, adding couple more GB wouldn’t change much.

 

Igor

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

Предыдущее
От: Charles Nadeau
Дата:
Сообщение: Re: [PERFORM] Very poor read performance, query independent
Следующее
От: Rick Otten
Дата:
Сообщение: Re: [PERFORM] Very poor read performance, query independent