pgsql: Improve fix for not entering parallel mode when holding interrup - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Improve fix for not entering parallel mode when holding interrup
Date
Msg-id E1t9Tw1-000rNI-O9@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Improve fix for not entering parallel mode when holding interrupts.

Commit ac04aa84a put the shutoff for this into the planner, which is
not ideal because it doesn't prevent us from re-using a previously
made parallel plan.  Revert the planner change and instead put the
shutoff into InitializeParallelDSM, modeling it on the existing code
there for recovering from failure to allocate a DSM segment.

However, that code path is mostly untested, and testing a bit harder
showed there's at least one bug: ExecHashJoinReInitializeDSM is not
prepared for us to have skipped doing parallel DSM setup.  I also
thought the Assert in ReinitializeParallelWorkers is pretty
ill-advised, and replaced it with a silent Min() operation.

The existing test case added by ac04aa84a serves fine to test this
version of the fix, so no change needed there.

Patch by me, but thanks to Noah Misch for the core idea that we
could shut off worker creation when !INTERRUPTS_CAN_BE_PROCESSED.
Back-patch to v12, as ac04aa84a was.

Discussion: https://postgr.es/m/CAC-SaSzHUKT=vZJ8MPxYdC_URPfax+yoA1hKTcF4ROz_Q6z0_Q@mail.gmail.com

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/6e39ca6e7edb97e12274607e285b6a4262b94af9

Modified Files
--------------
src/backend/access/transam/parallel.c | 9 +++++++++
src/backend/executor/nodeHashjoin.c   | 9 +++++++--
src/backend/optimizer/plan/planner.c  | 6 ------
3 files changed, 16 insertions(+), 8 deletions(-)


pgsql-committers by date:

Previous
From: Peter Geoghegan
Date:
Subject: pgsql: Avoid nbtree parallel scan currPos confusion.
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Fix our Windows stat() emulation to handle file sizes > 4GB.