8.2.13 commit is taking too much time

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?

Responses

Browse pgsql-performance by date

  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