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 = 2GBwork_mem = 100MBeffective_cache_size = 2GBmaintenance_work_mem = 500MBautovacuum = offwal_buffers = 64MBHow 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.
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных