Re: Updates are slow.. - Mailing list pgsql-general

From Tom Lane
Subject Re: Updates are slow..
Date
Msg-id 2998.1024029876@sss.pgh.pa.us
Whole thread Raw
In response to Re: Updates are slow..  ("Tom Burke" <lists@spamex.com>)
List pgsql-general
"Tom Burke" <lists@spamex.com> writes:
> 1) Does the 25 minute update of 600K rows with an index on the
>    email column still seem out of line or is there not much we can do?

Still seems out of line to me, but I'm unsure where the problem lies.
First off, is the system CPU-bound or I/O bound while this update
is running?

            regards, tom lane

pgsql-general by date:

Previous
From: "Graeme Merrall"
Date:
Subject: Re: read this and puke
Next
From: Ron Snyder
Date:
Subject: Re: read this and puke