Re: I/O - Increase RAM

It sounds as if you have *one* server with 128GB of memory.

Therefore the probabilities are that you have too many task running at the same time. Flushing the disk drives’ read/write cache.

Increasing the memory probably will not solve the problem. The most effective solution would be to separate the tasks that access the drive (read or write) often.

Alternatively if you have access to the code. Try to cache some of the disk activities.

The third solution would be to separate the tasks and move them to a different server.

Hope this helps.

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of drum(dot)lucas(at)gmail(dot)com
Sent: 13 April 2016 21:44
To: Postgres General
Subject: [GENERAL] I/O - Increase RAM

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.

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