RE: Parallel Inserts in CREATE TABLE AS

Поиск
Список
Период
Сортировка
От Hou, Zhijie
Тема RE: Parallel Inserts in CREATE TABLE AS
Дата
Msg-id 07313935e156485fb6abead534fe872d@G08CNEXMBPEKD05.g08.fujitsu.local
обсуждение исходный текст
Ответ на Re: Parallel Inserts in CREATE TABLE AS  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Ответы Re: Parallel Inserts in CREATE TABLE AS
Re: Parallel Inserts in CREATE TABLE AS
Список pgsql-hackers
Hi

> Attaching v11 patch set. Please review it further.

Currently with the patch, we can allow parallel CTAS when topnode is Gather.
When top-node is Append and Gather is the sub-node of Append, I think we can still enable 
Parallel CTAS by pushing Parallel CTAS down to the sub-node Gather, such as:

Append
------>Gather
--------->Create table
------------->Seqscan
------>Gather
--------->create table
------------->Seqscan

And the use case seems common to me, such as:
select * from A where xxx union all select * from B where xxx;

I attatch a WIP patch which just show the possibility of this feature.
The patch is based on the latest v11-patch.

What do you think?

Best regards,
houzj






Вложения

В списке pgsql-hackers по дате отправления: