ing (barely) acceptable performance from a single
15k U160 SCSI disk, but db size and activity are growing quickly.
I've got more disks and a battery-backed LSI card on order.
-mike
--
Mike Glover
GPG Key ID BFD19F2C <[EMAIL PROTECTED]>
pgp0.pgp
Description: PGP signature
ory available, you're swapping intermediate sort pages to disk --
a lot. Try the query with sort_mem set to 75MB (to do the entire sort in
memory).
-mike
> Cheers,
>
> Bradley.
>
>
> ---(end of
> broadcast)--- TIP 8: exp
Tom-
Thanks for the quick response. More details are inline.
-mike
On Thu, 01 Jan 2004 23:06:11 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Mike Glover <[EMAIL PROTECTED]> writes:
> AFAICS these plans are identical, and therefore the difference in
> runtime must be
obscenely long time to complete? The 175s (and even 216s) for the
select seems reasonable given the size of the tables, but not 3000s to
update the same rows. The processor (AMD 1.3GHz) is 90%+ utilization for
most of the execution time.
I can post more information if it would be helpful, but this post is
long enough already.
TIA, and happy new year.
-mike
--
Mike Glover
Key ID BFD19F2C <[EMAIL PROTECTED]>
pgp0.pgp
Description: PGP signature
