A GUC to prevent leader processes from running subplans?
Thomas Munro <thomas.munro@enterprisedb.com>
From: Thomas Munro <thomas.munro@enterprisedb.com>
To: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2017-10-17T11:27:05Z
Lists: pgsql-hackers
Attachments
- 0001-Add-a-GUC-to-control-whether-Gather-runs-subplans.patch (application/octet-stream) patch 0001
Hi hackers, While testing parallelism work I've wanted to be able to prevent gather nodes from running the plan in the leader process, and I've heard others say the same. One way would be to add a GUC "multiplex_gather", like in the attached patch. If you set it to off, Gather and Gather Merge won't run the subplan unless they have to because no workers could be launched. I thought about adding a new value for force_parallel_mode instead, but someone mentioned they might want to do this on a production system too and force_parallel_mode is not really for end users. Better ideas? -- Thomas Munro http://www.enterprisedb.com
Commits
-
Fix typo.
- ebc189e12259 11.0 landed
-
Add parallel_leader_participation GUC.
- e5253fdc4f5f 11.0 landed