Horton

Allow DML commands that create tables to use parallel query.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: e9baa5e9fa147e00a2466ab2c40eb99c8a700824
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-10-05T15:40:48Z
Releases: 11.0 
Allow DML commands that create tables to use parallel query.

Haribabu Kommi, reviewed by Dilip Kumar and Rafia Sabih.  Various
cosmetic changes by me to explain why this appears to be safe but
allowing inserts in parallel mode in general wouldn't be.  Also, I
removed the REFRESH MATERIALIZED VIEW case from Haribabu's patch,
since I'm not convinced that case is OK, and hacked on the
documentation somewhat.

Discussion: http://postgr.es/m/CAJrrPGdo5bak6qnPWe8Kpi8g_jfQEs-G4SYmG9y+OFaw2-dPvA@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/parallel.sgml modified +4 −12
src/backend/access/heap/heapam.c modified +9 −7
src/backend/commands/createas.c modified +2 −2
src/backend/commands/explain.c modified +1 −3
src/backend/executor/execMain.c modified +2 −4
src/backend/optimizer/plan/planner.c modified +10 −0
src/test/regress/expected/write_parallel.out added +79 −0
src/test/regress/parallel_schedule modified +1 −0
src/test/regress/serial_schedule modified +1 −0
src/test/regress/sql/write_parallel.sql added +42 −0

Documentation touched

Discussion