Re: [PERFORM] long-running query - needs tuning

2007-08-23 Thread Tom Lane
Kevin Kempter <[EMAIL PROTECTED]> writes: > Merge Join (cost=17118858.51..17727442.30 rows=155 width=90) >Merge Cond: ("outer".customer_id = "inner".customer_id) >-> GroupAggregate (cost=17118772.93..17727347.34 rows=155 width=8) > -> Sort (cost=17118772.93..17270915.95 rows=

[PERFORM] long-running query - needs tuning

2007-08-23 Thread Kevin Kempter
Hi List; I've just started working with a new client and they have amoung other issues with their databases a particular update that basically locks out users. The below query was running for over 6 hours this morning and the CPU load had climbed to a point where new connections simply hung wa