Re: Asynchronous Append on postgres_fdw nodes.

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>, "movead(dot)li" <movead(dot)li(at)highgo(dot)ca>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Asynchronous Append on postgres_fdw nodes.
Date: 2021-03-01 08:56:10
Message-ID: CAPmGK17kzTxbS=Av_HN3kKgeWTrt9Kwz5eO_UtKN1nDYLru=6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Feb 20, 2021 at 3:35 PM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> wrote:
> So I’ll update the patch using your patch without the
> postgresIterateForeignScan() change.

Here is an updated version of the patch. Based on your idea of
completing an in-progress command (if any) before sending a new
command to the remote, I created a function for that
process_pending_request(), and added it where needed in
contrib/postgres_fdw. I also adjusted the patch, and fixed some bugs
in the postgres_fdw part of the patch.

Best regards,
Etsuro Fujita

Attachment Content-Type Size
async-wip-2021-03-01.patch application/octet-stream 91.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2021-03-01 09:08:45 Re: repeated decoding of prepared transactions
Previous Message Amit Langote 2021-03-01 08:39:13 Re: A reloption for partitioned tables - parallel_workers