Thread: slow update query

slow update query

From
Patrick Hatcher
Date:



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