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: Tue, 11 Jul 2017 15:46:30 +0000
Message-ID: <DM5PR07MB28107393513C0A3B8C50F26BDAAE0@DM5PR07MB2810.namprd07.prod.outlook.com> (raw)
In-Reply-To: <CADFyZw6P82OeF24p6ArfuRwwLG4e=AbTdN3bRbN=UEfFPtKWpg@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>
<CADFyZw6P82OeF24p6ArfuRwwLG4e=AbTdN3bRbN=UEfFPtKWpg@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
From: Charles Nadeau [mailto:[email protected]]
Sent: Tuesday, July 11, 2017 11:25 AM
To: Igor Neyman <[email protected]>
Cc: [email protected]
Subject: Re: [PERFORM] Very poor read performance, query independent
Attention: This email was sent from someone outside of Perceptron. Always exercise caution when opening attachments or clicking links from unknown senders or when receiving unexpected emails.
Igor,
The sum of effective_cache_size and shared_buffer will be higher than the physical memory I have. Is it OK?
Thanks!
Charles
Yes, that’s normal.
shared_buffers is the maximum that Postgres allowed to allocate, while effective_cache_size is just a number that optimizer takes into account when creating execution plan.
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: <DM5PR07MB28107393513C0A3B8C50F26BDAAE0@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