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