Home > mailing lists

I/O - Increase RAM - Mailing list pgsql-general

From	drum.lucas@gmail.com
Subject	I/O - Increase RAM
Date	April 13, 2016 23:44:21
Msg-id	CAE_gQfX+gG6RF7Y7-vCcGc6dEpzsubw-E2yjT9kCKRNwsBT5=Q@mail.gmail.com Whole thread Raw
Responses	Re: I/O - Increase RAM Re: I/O - Increase RAM Re: I/O - Increase RAM Re: I/O - Increase RAM Re: I/O - Increase RAM
List	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.

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

From: Oliver Kohll
Date: 13 April 2016, 22:41:13
Subject: Re: SET prepared statement

From: "Joshua D. Drake"
Date: 13 April 2016, 23:52:40
Subject: Re: I/O - Increase RAM