Re: [PERFORM] How to reduce IOWAIT and CPU idle time?

2016-09-10 Thread Jeff Janes
On Sat, Sep 10, 2016 at 3:49 AM, Samir Magar wrote: > Hello, > > > My Application has normally 25 to 30 connections and it is doing lot of > insert/update/delete operation. > The database size is 100GB. > iowait is at 40% to 45 % and CPU idle time is at 45% to 50% > TOTAL RAM = 8 GB TOTAL CPU

Re: [PERFORM] How to reduce IOWAIT and CPU idle time?

2016-09-10 Thread Venkata B Nagothi
On Sat, Sep 10, 2016 at 8:49 PM, Samir Magar wrote: > Hello, > > > My Application has normally 25 to 30 connections and it is doing lot of > insert/update/delete operation. > The database size is 100GB. > iowait is at 40% to 45 % and CPU idle time is at 45% to 50% > TOTAL RAM = 8 GB TOTAL CPU

[PERFORM] How to reduce IOWAIT and CPU idle time?

2016-09-10 Thread Samir Magar
Hello, My Application has normally 25 to 30 connections and it is doing lot of insert/update/delete operation. The database size is 100GB. iowait is at 40% to 45 % and CPU idle time is at 45% to 50% TOTAL RAM = 8 GB TOTAL CPU = 4 postgresql.conf parametre: shared_buffers = 2GB work_mem = 100