Re: strange pauses

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Adrian Moisey" <adrian(at)careerjunction(dot)co(dot)za>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: strange pauses
Date: 2008-01-18 15:36:08
Message-ID: dcc563d10801180736n3dbec92k1baf2095783395fa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Jan 18, 2008 4:58 AM, Adrian Moisey <adrian(at)careerjunction(dot)co(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2008-01-18 19:14:31 Re: [OT] RAID controllers blocking one another?
Previous Message Sean Davis 2008-01-18 13:03:42 Re: [OT] RAID controllers blocking one another?