A GUC to prevent leader processes from running subplans?

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

Responses

Browse pgsql-hackers by date

  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