Horton

Re: [PATCH] Allow parallelism for plpgsql return expression after commit 556f7b7

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dilip Kumar <dilipbalaut@gmail.com>
Cc: DIPESH DHAMELIYA <dipeshdhameliya125@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-07-07T18:36:53Z
Lists: pgsql-hackers 
Dilip Kumar <dilipbalaut@gmail.com> writes:
> On Fri, Jul 4, 2025 at 9:56 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> So on the whole it seems like a research project requiring nontrivial
>> effort and probably yielding only marginal gains.  It's certainly not
>> going to yield a back-patchable fix for this performance regression.

> Yeah that's correct.

OK.  I pushed the one-liner (plus comment) fix.  If anyone does
feel like looking into allowing subplans to run in parallel in
this context, it's not stopping them from doing so.

			regards, tom lane

Commits

  1. Restore the ability to run pl/pgsql expression queries in parallel.

  2. Simplify executor's determination of whether to use parallelism.