On 04/13/2016 01:59 PM, drum.lucas@xxxxxxxxx wrote:
On 14 April 2016 at 08:52, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx
<mailto:jd@xxxxxxxxxxxxxxxxx>> wrote:
On 04/13/2016 01:43 PM, drum.lucas@xxxxxxxxx
<mailto:drum.lucas@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
