How to reduce IOWAIT and CPU idle time?

Поиск
Список
Период
Сортировка
От Samir Magar
Тема How to reduce IOWAIT and CPU idle time?
Дата
Msg-id CAA=to3ipKYw5LV=MJMe3gcMPKoiA-JQmDOduQB=mwxzzAV=T6A@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to reduce IOWAIT and CPU idle time?
Re: How to reduce IOWAIT and CPU idle time?
Re: How to reduce IOWAIT and CPU idle time?
Список pgsql-performance
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 = 100MB
effective_cache_size = 2GB
maintenance_work_mem = 500MB
autovacuum = off
wal_buffers = 64MB


How can i reduce iowait and CPU idle time. It is slowing all the queries. The queries that used to take 1 sec,it is taking 12-15 seconds.


version detials: 
Linux zabbix-inst.novalocal 3.10.0-229.7.2.el7.x86_64 #1 SMP Fri May 15 21:38:46 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux
database version: postgrsql 9.2.13 community.

Thanks,
Samir Magar

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Mike Sofen"
Дата:
Сообщение: Re: Postgres bulk insert/ETL performance on high speed servers - test results
Следующее
От: Venkata B Nagothi
Дата:
Сообщение: Re: How to reduce IOWAIT and CPU idle time?