Re: Very poor read performance, query independent

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 

 

From: Charles Nadeau [mailto:charles.nadeau@xxxxxxxxx]
Sent: Wednesday, July 12, 2017 3:21 AM
To: Igor Neyman <ineyman@xxxxxxxxxxxxxx>
Cc: pgsql-performance@xxxxxxxxxxxxxx
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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux