| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Baldur Norddahl <bbn-pgsql(dot)general(at)clansoft(dot)dk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: random delays |
| Date: | 2005-12-10 17:28:00 |
| Message-ID: | 87u0dgg8v3.fsf@stark.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> You'll find response times spike somewhat during Checkpoints. We've been
> working to reduce this effect for some time and there is still more work
> to be done.
>
> Tune your wal settings and bgwriter to improve things, plus upgrade to
> 8.1 which has made leaps forward with this issue.
If that's the problem presumably moving the WAL segments to a dedicated set of
spindles would help?
It seems to me it would take a pretty severe case of this to cause 10-20s
delays though. You aren't perchance running VACUUM FULL or any DDL like
REINDEX or CLUSTER periodically are you?
--
greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-10 17:59:42 | Re: alter table schema in 8.0 |
| Previous Message | Joshua D. Drake | 2005-12-10 17:16:33 | Re: Performance woes |