| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Adrian Moisey" <adrian(at)careerjunction(dot)co(dot)za> |
| Cc: | "Greg Smith" <gsmith(at)gregsmith(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: strange pauses |
| Date: | 2008-01-17 13:44:28 |
| Message-ID: | dcc563d10801170544n445433f6m958c9b2ca83558d5@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Jan 17, 2008 12:50 AM, Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za> wrote:
> Hi
>
> >> Search this list for references to "checkpoints". If you run
> >> vmstat/iostat for a bit you should see bursts of disk activity at
> >> those times.
> >
> > The most straightforward way to prove or disprove that the slow queries
> > line up with checkpoints is to set to checkpoint_warning to a high value
> > (3600 should work), which should log every checkpoint, and then see if
> > they show up at the same time in the logs.
>
> You guys were spot on. During these pauses the IO goes up high.
You need to tune your background writer process. See this link:
http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Davis | 2008-01-17 20:17:08 | [OT] RAID controllers blocking one another? |
| Previous Message | Brian Herlihy | 2008-01-17 09:16:40 | Re: strange pauses |