Postgres Pro
Downloads
Home   >   mailing lists

Re: How to reduce IOWAIT and CPU idle time? - Mailing list pgsql-performance

From Pavan Deolasee
Subject Re: How to reduce IOWAIT and CPU idle time?
Date
Msg-id CABOikdN0apPYNruDczLbMQp5h+7uKGwCDtX+3GzBuUBiK3XXfg@mail.gmail.com
Whole thread Raw
In response to How to reduce IOWAIT and CPU idle time?  (Samir Magar <samirmagar8@gmail.com>)
List pgsql-performance
Tree view


On Sat, Sep 10, 2016 at 4:19 PM, Samir Magar <samirmagar8@gmail.com> 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 = 4 

postgresql.conf parametre:


autovacuum = off


That could be the source of your problem. Why autovacuum is turned off? Has database grown from 5GB to 100GB because of bloat or so much new data has been inserted? If it's a bloat, vacuum may not now be enough to recover from that and you would need a vacuum full. In general, it's not a good idea to turn autovacuum off.

Thanks,
Pavan

--
 Pavan Deolasee                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-performance by date:

Previous
From: Samir Magar
Date:
Subject: Re: How to reduce IOWAIT and CPU idle time?
Next
From: Samir Magar
Date:
Subject: Re: How to reduce IOWAIT and CPU idle time?