On 4/13/2016 1:43 PM, drum.lucas@xxxxxxxxx wrote:
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.
depends on if its read or write IO. many of our database servers are nearly 100% write IO, only thing that will speed that up is faster disks and/or more disks in raid10.
-- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general