On Tue, Sep 10, 2024 at 4:49 PM Fabrice Chapuis <fabrice636...@gmail.com> wrote:
> no lock, in view pg_stat_activity > > status = active > wait event = NULL > wait event type = NULL > > On Mon, Sep 9, 2024 at 5:00 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > >> 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 >> >
