Re: [PERFORM] Slow update statement

2005-08-07 Thread Patrick Hatcher
Sorry went out of town for the weekend. The update did occur, but I have no idea when it finished. Here's the actual query and the explain Update: cdm.bcp_ddw_ck_cus = 12.7 M cdm.cdm_ddw_customer = 12.8M explain update cdm.cdm_ddw_customer set indiv_fkey

Re: [PERFORM] Slow update statement

2005-08-07 Thread Patrick Hatcher
Sorry went out of town for the weekend. The update did occur, but I have no idea when it finished. Here's the actual query and the explain Update: cdm.bcp_ddw_ck_cus = 12.7 M cdm.cdm_ddw_customer = 12.8M explain update cdm.cdm_ddw_customer set indiv_fkey =

Re: [PERFORM] Slow update statement

2005-08-07 Thread Tom Lane
Patrick Hatcher <[EMAIL PROTECTED]> writes: > Hash Join (cost=1246688.42..4127248.31 rows=12702676 width=200) >Hash Cond: ("outer".cus_num = "inner".cus_nbr) >-> Seq Scan on bcp_ddw_ck_cus b (cost=0.00..195690.76 rows=12702676 > width=16) >-> Hash (cost=874854.34..874854.34 rows=

Re: [PERFORM] Slow update statement

2005-08-07 Thread Patrick Hatcher
At the time this was the only process running on the box so I set sort_mem= 228000; It's a 12G box. Tom Lane wrote: Patrick Hatcher <[EMAIL PROTECTED]> writes: Hash Join (cost=1246688.42..4127248.31 rows=12702676 width=200) Hash Cond: ("outer".cus_num = "inner".cus_nbr) -> Seq Scan o