Re: Asynchronous Append on postgres_fdw nodes.

From: "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru>
To: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, "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: 2020-12-10 06:38:04
Message-ID: 4bdaf2f5-00b9-7e62-349d-ea3dbff7c36b@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/17/20 2:56 PM, Etsuro Fujita wrote:
> On Mon, Oct 5, 2020 at 3:35 PM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> wrote:
> Comments welcome! The attached is still WIP and maybe I'm missing
> something, though.
I reviewed your patch and used it in my TPC-H benchmarks. It is still
WIP. Will you improve this patch?

I also want to say that, in my opinion, Horiguchi-san's version seems
preferable: it is more structured, simple to understand, executor-native
and allows to reduce FDW interface changes. This code really only needs
one procedure - IsForeignPathAsyncCapable.

--
regards,
Andrey Lepikhov
Postgres Professional

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Nancarrow 2020-12-10 07:08:17 Re: Parallel INSERT (INTO ... SELECT ...)
Previous Message Dilip Kumar 2020-12-10 06:24:46 Re: Parallel INSERT (INTO ... SELECT ...)