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)
Список
Дерево обсуждения
Re: Asynchronous Append on postgres_fdw nodes. "movead.li@highgo.ca" <movead.li@highgo.ca>
Re: Asynchronous Append on postgres_fdw nodes. Craig Ringer <craig.ringer@enterprisedb.com>
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita <etsuro.fujita@gmail.com>
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita <etsuro.fujita@gmail.com>
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 по дате отправления