public inbox for [email protected]
help / color / mirror / Atom feedFrom: Igor Neyman <[email protected]>
To: Charles Nadeau <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Very poor read performance, query independent
Date: Wed, 12 Jul 2017 13:57:06 +0000
Message-ID: <DM5PR07MB281020250424625EAAFDD77ADAAF0@DM5PR07MB2810.namprd07.prod.outlook.com> (raw)
In-Reply-To: <CADFyZw6+EEovy7wagTQSdUW4Mk4cbj-Yo+K9MS+Vn2i-HQys1g@mail.gmail.com>
References: <CADFyZw7aGoD0AaStxdyHByR5Qta=M5wx0v=iptKLhPUp+EOKvA@mail.gmail.com>
<[email protected]>
<CADFyZw4UanW5TbFajWKWhN9XcW+8gtCXw+kssHo47Wpr1A=zJw@mail.gmail.com>
<DM5PR07MB28103FD558CB6628CECE07BEDAA90@DM5PR07MB2810.namprd07.prod.outlook.com>
<CADFyZw5ucD=KNrmnxz23NBW5_YJXW731E4LDp=+LjycjnmBRNw@mail.gmail.com>
<DM5PR07MB281050555F2D7BFDD66A37BADAAE0@DM5PR07MB2810.namprd07.prod.outlook.com>
<DM5PR07MB2810B33E4FB7E55B60832597DAAE0@DM5PR07MB2810.namprd07.prod.outlook.com>
<CADFyZw6+EEovy7wagTQSdUW4Mk4cbj-Yo+K9MS+Vn2i-HQys1g@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
From: Charles Nadeau [mailto:[email protected]]
Sent: Wednesday, July 12, 2017 3:21 AM
To: Igor Neyman <[email protected]>
Cc: [email protected]
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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Very poor read performance, query independent
In-Reply-To: <DM5PR07MB281020250424625EAAFDD77ADAAF0@DM5PR07MB2810.namprd07.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox