On 04/13/2016 01:59 PM, [email protected] wrote:
On 14 April 2016 at 08:52, Joshua D. Drake <[email protected]
<mailto:[email protected]>> wrote:
On 04/13/2016 01:43 PM, [email protected]
<mailto:[email protected]> wrote:
Question:
I know that might not be the best option, but by increasing the
RAM and
the CACHE would help, right?
might, not necessarily would.
Would be nice if you could explain why not / why yes
For reads the more things in cache the more performance.
For writes the topic is more complicated but the long and short is this:
The moment you flush your cache (evict a bunch of buffers, linux dumping
out its cache etc..) you are going to get hammered.
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
