From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
---|---|
To: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | A GUC to prevent leader processes from running subplans? |
Date: | 2017-10-17 11:27:05 |
Message-ID: | CAEepm=2U++Lp3bNTv2Bv_kkr5NE2pOyHhxU=G0YTa4ZhSYhHiw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
Attachment | Content-Type | Size |
---|---|---|
0001-Add-a-GUC-to-control-whether-Gather-runs-subplans.patch | application/octet-stream | 6.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2017-10-17 12:29:22 | Re: SIGSEGV in BRIN autosummarize |
Previous Message | Alvaro Herrera | 2017-10-17 10:59:16 | Re: SIGSEGV in BRIN autosummarize |