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
