From: | AI Rumman <rummandba(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | 8.2.13 commit is taking too much time |
Date: | 2011-05-10 07:01:04 |
Message-ID: | BANLkTimRRj1KX5YXWyjcc9wQZJuEMgxAsA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
I am using Postgresql 8.2.13 and I found that most of the commits and insert
or update statements are taking more than 4s in the db and the app
performance is slow for that.
My db settings are as follows;
bgwriter_all_maxpages | 300 |
bgwriter_all_percent | 15 |
bgwriter_delay | 300 | ms
bgwriter_lru_maxpages | 50 |
bgwriter_lru_percent | 10 |
SHOW checkpoint_segments ;
checkpoint_segments
---------------------
300
(1 row)
show work_mem ;
work_mem
----------
16MB
(1 row)
show checkpoint_timeout ;
checkpoint_timeout
--------------------
5min
(1 row)
show checkpoint_warning ;
checkpoint_warning
--------------------
30s
(1 row)
show shared_buffers ;
shared_buffers
----------------
4GB
(1 row)
I have 32 gb RAM and its a 4*2=8 core processors.
Any idea how to improve the performance?
From | Date | Subject | |
---|---|---|---|
Next Message | Sethu Prasad | 2011-05-10 07:23:13 | Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 |
Previous Message | Yeb Havinga | 2011-05-10 06:58:21 | Re: Benchmarking a large server |