Search Postgresql Archives

Re: I/O - Increase RAM

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of drum.lucas@xxxxxxxxx
Sent: 13 April 2016 21:44
To: Postgres General
Subject: 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux