slow update query

From: Patrick Hatcher <PHatcher(at)macys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: slow update query
Date: 2005-08-05 16:55:55
Message-ID: OFE3BD824D.BC1545CB-ON88257054.005C70A4-88257054.005D02FB@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F. O'Connell 2005-08-05 17:49:10 Re: initskript after db start; locks on transactions
Previous Message Yudie Pg 2005-08-05 15:53:19 How to join function with a table?