From: Tom Lane <tgl@sss.pgh.pa.us>
To: Shane Wright <me@shanewright.co.uk>
Cc: pgsql-admin@postgresql.org
Subject: Re: hanging for 30sec when checkpointing
Date: Tue, 03 Feb 2004 18:44:18 -0500
Message-ID: <3020.1075851858@sss.pgh.pa.us> (raw)
In-Reply-To: <40202216.4010608@shanewright.co.uk>
References: <40202216.4010608@shanewright.co.uk>
Shane Wright <me@shanewright.co.uk> writes:
> When the db is under medium-heavy load, it periodically spawns a
> 'checkpoint subprocess' which runs for between 15 seconds and a minute.
It sounds like checkpoint is saturating your disk bandwidth.
> I've looked at the documentation and various bits about adjusting
> checkpoint segments and timings - but it seems reducing segments/timeout
> is implied to be bad, but it seems to me that increasing either will
> just make the same thing happen less often but more severely.
I was actually just about to suggest reducing the inter-checkpoint
interval. That should reduce the volume of data that needs to be
written per checkpoint. Might spread the pain a little thinner at least.
If you think you should have more disk bandwidth available than the
system seems to be using, maybe there is something wrong with the disk
or kernel configuration, but that's way out of my league to diagnose.
You'd probably need to find some kernel hackers to help you with that.
BTW, Jan Wieck has been doing some work recently to try to reduce the
"I/O storm at checkpoint" effect, but it won't appear till 7.5.
regards, tom lane
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, me@shanewright.co.uk
Subject: Re: hanging for 30sec when checkpointing
In-Reply-To: <3020.1075851858@sss.pgh.pa.us>
References: <40202216.4010608@shanewright.co.uk> <3020.1075851858@sss.pgh.pa.us>
* 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