Postgres Pro
Downloads
Home   >   mailing lists

Re: infinite loop in an update statement - Mailing list pgsql-general

From Fabrice Chapuis
Subject Re: infinite loop in an update statement
Date
Msg-id CAA5-nLD9tFX_AMNP2hbh_OD2FHoSfjp0PQHR4BTzDNO4NvUiBg@mail.gmail.com
Whole thread Raw
In response to infinite loop in an update statement  (Fabrice Chapuis <fabrice636861@gmail.com>)
Responses Re: infinite loop in an update statement
List pgsql-general
Tree view


On Tue, Sep 10, 2024 at 4:49 PM Fabrice Chapuis <fabrice636861@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 <tgl@sss.pgh.pa.us> wrote:
Fabrice Chapuis <fabrice636861@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

pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Recommendations on improving the insert on conflict do nothing performance
Next
From: Thomas Munro
Date:
Subject: Re: Error:could not extend file " with FileFallocate(): No space left on device