Re: Asynchronous Append on postgres_fdw nodes.
От | David Steele |
---|---|
Тема | Re: Asynchronous Append on postgres_fdw nodes. |
Дата | |
Msg-id | 1db062e4-12b7-2cf5-fa10-b6747e666656@pgmasters.net обсуждение исходный текст |
Ответ на | Asynchronous Append on postgres_fdw nodes. (Kyotaro Horiguchi <horikyota.ntt@gmail.com>) |
Ответы |
Re: Asynchronous Append on postgres_fdw nodes.
|
Список | pgsql-hackers |
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@pgmasters.net
В списке pgsql-hackers по дате отправления: