Re: Update from other tables slow

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca> writes:
> Is there anything wrong with this UPDATE statement?

> update mdx_core.provider
> set 
>    middle_name = fix.middle_name, 
>    display_name = fix.display_name
> from mdx_import._fix_mnames as fix
> where provider.provider_id = fix.provider_id;

Who's to say?  You haven't showed us EXPLAIN data nor mentioned what
PG version you are running.

I'd ask for EXPLAIN ANALYZE, but if you aren't willing to wait for the
query to finish, that's a non-starter.  It would be good to show EXPLAIN
ANALYZE output for the variant that does finish, though.

			regards, tom lane