Skip site navigation (1) Skip section navigation (2)

Re: server gets slow at certain time

From: Thom Brown <thom(at)linux(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: server gets slow at certain time
Date: 2010-10-29 12:40:20
Message-ID: AANLkTi=j9FcXmbAmvBOougvu0gaV0nw3fe6xPc_-hcQw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On 29 October 2010 13:24, AI Rumman <rummandba(at)gmail(dot)com> wrote:

> I am using Postgresql 8.1 in 8-cpu cores with 32 gb ram with CestOS 5.
> I have different DBs in the system and the large one is 12 GB and it is a
> CRM DB and heavily used.
> Every day after 1 pm the system gets slow and after analyzing the nmon
> spreadsheet, I found that IO spike at that period.
> Users write data much at that period of time.
> DB parameters are as follows:
> max_connections= 500
> shared_buffers=122144
> effective_cache_size = 1835010
> work_mem = 8192
> max_fsm_pages= 356656
> fsync=on
> commit_delay=0
> commit_siblings= 5
> random_page_cost = 0.01
> default_statistics_target=100
> wah_buffers = 500
>
> Any idea please how to find the bottleneck and improve performance.
> Let me know if any more information is needed.
>
>
What's your checkpoint_segments setting?  You may wish to up it if you're
getting many inserts/updates.

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

In response to

Responses

pgsql-general by date

Next:From: Devrim GÜNDÜZDate: 2010-10-29 12:49:13
Subject: Re: server gets slow at certain time
Previous:From: AI RummanDate: 2010-10-29 12:24:58
Subject: server gets slow at certain time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group