Re: Asynchronous Append on postgres_fdw nodes.

On 2/28/20 3:06 AM, Kyotaro Horiguchi wrote:
> Hello, this is a follow-on of [1] and [2].
>
> Currently the executor visits execution nodes one-by-one. Considering
> sharding, Append on multiple postgres_fdw nodes can work
> simultaneously and that can largely shorten the respons of the whole
> query. For example, aggregations that can be pushed-down to remote
> would be accelerated by the number of remote servers. Even other than
> such an extreme case, collecting tuples from multiple servers also can
> be accelerated by tens of percent [2].
>
> I have suspended the work waiting asyncrohous or push-up executor to
> come but the mood seems inclining toward doing that before that to
> come [3].
>
> The patchset consists of three parts.

Are these improvements targeted at PG13 or PG14? This seems to be a
pretty big change for the last CF of PG13.

Regards,
--
-David
david(at)pgmasters(dot)net