Re: Parallel INSERT (INTO ... SELECT ...) - Mailing list pgsql-hackers

From Greg Nancarrow
Subject Re: Parallel INSERT (INTO ... SELECT ...)
Date
Msg-id CAJcOf-f7f_-Q9pYYOMg_S6EeO_WGy=eCGqZZ03oxy7UPJOYDzw@mail.gmail.com
Whole thread Raw
In response to Re: Parallel INSERT (INTO ... SELECT ...)  (Greg Nancarrow <gregn4422@gmail.com>)
Responses Re: Parallel INSERT (INTO ... SELECT ...)  (Greg Nancarrow <gregn4422@gmail.com>)
List pgsql-hackers
Posting an updated set of patches. Changes are based on feedback, as
detailed below:

[Amit Langote]
- Integrate max_parallel_hazard_for_modify() with max_parallel_hazard()
- Some function name changes
- Fix partition-related problems (to handle concurrent attachment of
partitions and altering of partitions, plan cache invalidation) and
added some tests for this.
(Method of fixing yet to be verified)
[Hou-san]
- Merge is_parallel_possible_for_modify() from the parallel_dml patch,
which helps in placement of some short-circuits of parallel-safety
checks
- Minor update to documentation for temp and foreign tables
[Greg]
- Temporary fix for query rewriter hasModifyingCTE bug (without
changing query rewriter code - note that v15 patch put fix in query
rewriter)

Hou-san: the parallel_dml patches will need slight rebasing.


Regards,
Greg Nancarrow
Fujitsu Australia

Attachment

pgsql-hackers by date:

Previous
From: Markus Wanner
Date:
Subject: Re: repeated decoding of prepared transactions
Next
From: Dilip Kumar
Date:
Subject: Re: [HACKERS] Custom compression methods