pgsql: Allow DML commands that create tables to use parallel query.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow DML commands that create tables to use parallel query.
Date: 2017-10-05 15:43:48
Message-ID: E1e08JQ-000521-HD@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/e9baa5e9fa147e00a2466ab2c40eb99c8a700824

Modified Files
--------------
doc/src/sgml/parallel.sgml | 16 ++----
src/backend/access/heap/heapam.c | 16 +++---
src/backend/commands/createas.c | 4 +-
src/backend/commands/explain.c | 4 +-
src/backend/executor/execMain.c | 6 +--
src/backend/optimizer/plan/planner.c | 10 ++++
src/test/regress/expected/write_parallel.out | 79 ++++++++++++++++++++++++++++
src/test/regress/parallel_schedule | 1 +
src/test/regress/serial_schedule | 1 +
src/test/regress/sql/write_parallel.sql | 42 +++++++++++++++
10 files changed, 151 insertions(+), 28 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2017-10-05 16:24:03 Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple
Previous Message Tom Lane 2017-10-05 14:52:27 Re: [COMMITTERS] pgsql: Allow multiple tables to be specified in one VACUUM or ANALYZE c