|From: John R Pierce Sent: Wednesday, April 13, 2016 1:53 PM | |On 4/13/2016 1:43 PM, drum.lu...@gmail.com 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
Agree with John and also add that if your READ queries or data model are not optimized then you could throw a TB of ram at it and see no difference. You need to analyze your queries and find out WHY there's so much i/o. It sounds like thrash to me...so you need to do some homework and get the behaviors sorted out, then it should become obvious what needs fixing. Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
