Pg 7.4.5 I'm running an update statement on about 2 million records using the following query: Update table_A set F1 = b.new_data from table_B b where b.keyfield = table_A.keyfield both keyfields are indexed, yet this job has been running over 3 hours. Is this normal? thanks Patrick Hatcher Macys.Com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
