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