I/O - Increase RAM

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: I/O - Increase RAM
Date: 2016-04-13 20:43:35
Message-ID: CAE_gQfX+gG6RF7Y7-vCcGc6dEpzsubw-E2yjT9kCKRNwsBT5=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

At the moment I'm having 100% I/O during the day. My server has SATA HDs,
and it can't be changed now.
So, to solve the problem (or at least try) I was thinking about double the
RAM, and by doing that, increasing the cache.

[image: Inline images 1]

The server has 128GB today:

shared_buffers = 51605MB (I'll change it to 32GB)
> effective_cache_size = 96760MB

Question:

I know that might not be the best option, but by increasing the RAM and the
CACHE would help, right?

Thanks
Lucas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2016-04-13 20:52:29 Re: I/O - Increase RAM
Previous Message Oliver Kohll 2016-04-13 19:41:07 Re: SET prepared statement