Re: Inherited UPDATE/DELETE vs async execution

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org>
Subject: Re: Inherited UPDATE/DELETE vs async execution
Date: 2021-05-10 02:20:09
Message-ID: CAPmGK17T-Mv5jKrru_R0D0EDYUui8Cvp-=sGuaNMB26EqkaLHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, May 10, 2021 at 9:20 AM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> On Sat, May 08, 2021 at 01:20:51AM +0900, Etsuro Fujita wrote:
> > I noticed this while working on the
> > EXPLAIN-ANALYZE-for-async-capable-nodes issue:
> >
> > DELETE FROM async_pt;
> > server closed the connection unexpectedly
>
> Confirmed, +Tomas, and added at
> https://wiki.postgresql.org/wiki/PostgreSQL_14_Open_Items

Thanks for that!

Maybe my explanation was not good, but actually, this is a follow-up
for commits 27e1f1456 and 86dc90056, which were independently
discussed and committed, and IIUC, the batch-insert work by Tomas
would not be related to this. So I’ll work on it unless Tom (or
anyone else) wants to.

Best regards,
Etsuro Fujita

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2021-05-10 03:03:08 Re: Asynchronous Append on postgres_fdw nodes.
Previous Message Peter Smith 2021-05-10 02:20:00 Re: AlterSubscription_refresh "wrconn" wrong variable?