From: Scott Marlowe <scott.marlowe@gmail.com>
To: Adrian Moisey <adrian@careerjunction.co.za>
Cc: pgsql-performance@postgresql.org
Subject: Re: strange pauses
Date: Fri, 18 Jan 2008 09:36:08 -0600
Message-ID: <dcc563d10801180736n3dbec92k1baf2095783395fa@mail.gmail.com> (raw)
In-Reply-To: <4790863E.4000309@careerjunction.co.za>
References: <478DDF83.8070106@careerjunction.co.za>
<478DE16F.50308@archonet.com>
<4790863E.4000309@careerjunction.co.za>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, adrian@careerjunction.co.za
Subject: Re: strange pauses
In-Reply-To: <dcc563d10801180736n3dbec92k1baf2095783395fa@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox