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.
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