| From: | Samir Magar <samirmagar8(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | How to reduce IOWAIT and CPU idle time? |
| Date: | 2016-09-10 10:49:57 |
| Message-ID: | CAA=to3ipKYw5LV=MJMe3gcMPKoiA-JQmDOduQB=mwxzzAV=T6A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Venkata B Nagothi | 2016-09-11 00:34:41 | Re: How to reduce IOWAIT and CPU idle time? |
| Previous Message | Mike Sofen | 2016-09-08 02:28:46 | Re: Postgres bulk insert/ETL performance on high speed servers - test results |