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
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: David Steele
Дата:
От: Georgios Kokolatos
Дата:
FAQ