From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: A long-running transaction
Date: Tue, 3 Apr 2007 16:14:20 -0400
Message-ID: <20070403201420.GB1519@phlogiston.dyndns.org> (raw)
In-Reply-To: <461261AD.6060108@herakles.homelinux.org>
References: <461261AD.6060108@herakles.homelinux.org>
On Tue, Apr 03, 2007 at 10:16:13PM +0800, John Summerfield wrote:
> It is hitting the disk pretty hard now on this machine, but the laptop's
> still going too, and the disk seems to run about half the time, part of
> a second running, part idle (but the intervals are getting shorter).
>
> It struck me as fairly curious that neither postgresql nor the
> application was hogging the CPU.
Why? Nothing about this seems likely CPU bound. It's probably I/O.
I note is number:
> IOwait: 2d 0:46:37.33 28.5% page dea: 16218135
which is pretty awful. Also
> For each record, I update a non-key field in another table; the source
> data for that other table is less than a megabyte.
this is a real issue. Basically, you're constrained at the rotation
speed of your disk, because for each record, you have to first find
then update one row somewhere else.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The plural of anecdote is not data.
--Roger Brinner
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-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: A long-running transaction
In-Reply-To: <20070403201420.GB1519@phlogiston.dyndns.org>
* 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