Postgres Pro
Downloads
Home   >   mailing lists

slow update query - Mailing list pgsql-general

From Patrick Hatcher
Subject slow update query
Date
Msg-id OFE3BD824D.BC1545CB-ON88257054.005C70A4-88257054.005D02FB@fds.com
Whole thread Raw
List pgsql-general
Tree view 



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

pgsql-general by date:

Previous
From: Yudie Pg
Date:
Subject: How to join function with a table?
Next
From: "Thomas F. O'Connell"
Date:
Subject: Re: initskript after db start; locks on transactions