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

Re: io storm on checkpoints, postgresql 8.2.4, linux

From: "Dmitry Potapov" <fortune(dot)fish(at)gmail(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: io storm on checkpoints, postgresql 8.2.4, linux
Date: 2007-08-22 16:22:59
Message-ID: 878c83960708220922n747c8485r30584d3ef793ec2e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
2007/8/22, Joshua D. Drake <jd(at)commandprompt(dot)com>:

> >     We've run into an issue of IO storms on checkpoints. Once in 20min
> > (which is checkpoint_interval) the database becomes unresponsive for
> about
> > 4-8 seconds. Query processing is suspended, server does nothing but
> writing
>
> What are your background writer settings?
>
>
bgwriter_delay=100ms
bgwriter_lru_percent=20.0
bgwriter_lru_maxpages=100
bgwriter_all_percent=3
bgwriter_all_maxpages=600


In fact, with dirty_background_ratio > 0 bgwriter even make things a tiny
bit worse.
-- 
Regards,
            Dmitry

In response to

pgsql-performance by date

Next:From: Dmitry PotapovDate: 2007-08-22 16:28:00
Subject: Re: io storm on checkpoints, postgresql 8.2.4, linux
Previous:From: Dmitry PotapovDate: 2007-08-22 16:16:15
Subject: Re: io storm on checkpoints, postgresql 8.2.4, linux

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