Fabrice Chapuis <fabrice636...@gmail.com> writes: > why this update does not return instantly?
> UPDATE table_a a
> SET col1 = (SELECT MIN(b.col1)
> FROM table_b b
> WHERE b.col2 = a.col2)
Maybe query is waiting for a lock on one of those tables?
regards, tom lane
