Re: strange pauses - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: strange pauses
Date
Msg-id dcc563d10801180736n3dbec92k1baf2095783395fa@mail.gmail.com
Whole thread Raw
In response to Re: strange pauses  (Adrian Moisey <adrian@careerjunction.co.za>)
List pgsql-performance
On Jan 18, 2008 4:58 AM, Adrian Moisey <adrian@careerjunction.co.za> wrote:
>
> We use a lot of checkpoints in our database, we don't care about these
> much.  We think this is causing the checkpoint to write a lot of data at
> checkpoint time.  Can we stop this behavior ?

You can smooth out the checkpoint behaviour by using that link I
posted earlier to tune your bgwriter to write things out ahead of when
the checkpoint will occurr.

pgsql-performance by date:

Previous
From: "Sean Davis"
Date:
Subject: Re: [OT] RAID controllers blocking one another?
Next
From: Greg Smith
Date:
Subject: Re: [OT] RAID controllers blocking one another?