On Tue, Sep 10, 2024 at 4:49 PM Fabrice Chapuis <[email protected]> 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 <[email protected]> wrote: > >> Fabrice Chapuis <[email protected]> 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 >> >
