slow update query

Started by Patrick Hatcherover 20 years ago1 messagesgeneral
Jump to latest
#1Patrick Hatcher
PHatcher@macys.com

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