On 29 October 2010 14:34, AI Rumman wrote:
> At present,
> checkpoint_segment=3
> checkpoint_timeout=300
>
>
I'd recommend at least setting checkpoint_segments to 12 and you might want
to increase checkpoint_timeout too, although not too high. Maybe try
doubling it.
And as Devrim pointed out, p
At present,
checkpoint_segment=3
checkpoint_timeout=300
On 10/29/10, Thom Brown wrote:
> On 29 October 2010 13:24, AI Rumman 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 a
On Fri, 2010-10-29 at 18:24 +0600, AI Rumman wrote:
> I am using Postgresql 8.1 in 8-cpu cores with 32 gb ram with CestOS 5.
In addition to what Thom wrote, please note that checkpoints in pre-8.3
negative effect on disk I/O -- you may see spikes during checkpoints.
--
Devrim GÜNDÜZ
PostgreSQL
On 29 October 2010 13:24, AI Rumman 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
> spr
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 w
