Re: I/O - Increase RAM

On 04/13/2016 01:59 PM, drum.lucas@gmail.com wrote:
>
>
> On 14 April 2016 at 08:52, Joshua D. Drake <jd@commandprompt.com
> <mailto:jd@commandprompt.com>> wrote:
>
>     On 04/13/2016 01:43 PM, drum.lucas@gmail.com
>     <mailto:drum.lucas@gmail.com> 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.