I have a query that does this:
update tab_x set (inactive_dt, last_update_dt) =
((select run_dt from current_run_date), (select run_dt from
cust_id::text || loc_id::text in
(select cust_id::text || loc_id::text from summary_tab);
The current_run_date table has only 1 row in it
the summary_tab table has 0 rows and the tab_x had 450,000 rows
The update takes 45min even though there is no rows to update.
I have a compound index (cust_id, loc_id) on both tables (summary_tab
How can I speed this up ?
Thanks in advance for any thoughts, suggestions, etc...
pgsql-performance by date
|Next:||From: A. Kretschmer||Date: 2008-05-20 06:15:48|
|Subject: Re: slow update|
|Previous:||From: PFC||Date: 2008-05-19 17:14:48|
|Subject: Re: I/O on select count(*)|