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