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
da...@pgmasters.net
