diff -w -U3 C:/cirrus/src/test/regress/expected/partition_join.out C:/cirrus/build/testrun/regress/regress/results/partition_join.out
--- C:/cirrus/src/test/regress/expected/partition_join.out	2024-04-18 13:26:53.118748000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/partition_join.out	2024-04-18 13:30:33.888023600 +0000
@@ -511,24 +511,29 @@
 			  (SELECT * FROM prt1 t2 TABLESAMPLE SYSTEM (t1.a) REPEATABLE(t1.b)) s
 			  ON t1.a = s.a;
                          QUERY PLAN                          
--------------------------------------------------------------
- Append
+-------------------------------------------------------------------------
+ Gather
+   Workers Planned: 2
+   ->  Parallel Append
    ->  Nested Loop
-         ->  Seq Scan on prt1_p1 t1_1
+               ->  Parallel Seq Scan on prt1_p1 t1_1
+               ->  Materialize
          ->  Sample Scan on prt1_p1 t2_1
                Sampling: system (t1_1.a) REPEATABLE (t1_1.b)
                Filter: (t1_1.a = a)
    ->  Nested Loop
-         ->  Seq Scan on prt1_p2 t1_2
+               ->  Parallel Seq Scan on prt1_p2 t1_2
+               ->  Materialize
          ->  Sample Scan on prt1_p2 t2_2
                Sampling: system (t1_2.a) REPEATABLE (t1_2.b)
                Filter: (t1_2.a = a)
    ->  Nested Loop
-         ->  Seq Scan on prt1_p3 t1_3
+               ->  Parallel Seq Scan on prt1_p3 t1_3
+               ->  Materialize
          ->  Sample Scan on prt1_p3 t2_3
                Sampling: system (t1_3.a) REPEATABLE (t1_3.b)
                Filter: (t1_3.a = a)
-(16 rows)
+(21 rows)
 
 -- lateral reference in scan's restriction clauses
 EXPLAIN (COSTS OFF)
@@ -2042,34 +2047,41 @@
 			  (SELECT * FROM prt1_l t2 TABLESAMPLE SYSTEM (t1.a) REPEATABLE(t1.b)) s
 			  ON t1.a = s.a AND t1.b = s.b AND t1.c = s.c;
                                        QUERY PLAN                                       
-----------------------------------------------------------------------------------------
- Append
+----------------------------------------------------------------------------------------------------
+ Gather
+   Workers Planned: 2
+   ->  Parallel Append
    ->  Nested Loop
-         ->  Seq Scan on prt1_l_p1 t1_1
+               ->  Parallel Seq Scan on prt1_l_p1 t1_1
+               ->  Materialize
          ->  Sample Scan on prt1_l_p1 t2_1
                Sampling: system (t1_1.a) REPEATABLE (t1_1.b)
                Filter: ((t1_1.a = a) AND (t1_1.b = b) AND ((t1_1.c)::text = (c)::text))
    ->  Nested Loop
-         ->  Seq Scan on prt1_l_p2_p1 t1_2
-         ->  Sample Scan on prt1_l_p2_p1 t2_2
-               Sampling: system (t1_2.a) REPEATABLE (t1_2.b)
-               Filter: ((t1_2.a = a) AND (t1_2.b = b) AND ((t1_2.c)::text = (c)::text))
-   ->  Nested Loop
-         ->  Seq Scan on prt1_l_p2_p2 t1_3
+               ->  Parallel Seq Scan on prt1_l_p2_p2 t1_3
+               ->  Materialize
          ->  Sample Scan on prt1_l_p2_p2 t2_3
                Sampling: system (t1_3.a) REPEATABLE (t1_3.b)
                Filter: ((t1_3.a = a) AND (t1_3.b = b) AND ((t1_3.c)::text = (c)::text))
    ->  Nested Loop
-         ->  Seq Scan on prt1_l_p3_p1 t1_4
+               ->  Parallel Seq Scan on prt1_l_p2_p1 t1_2
+               ->  Materialize
+                     ->  Sample Scan on prt1_l_p2_p1 t2_2
+                           Sampling: system (t1_2.a) REPEATABLE (t1_2.b)
+                           Filter: ((t1_2.a = a) AND (t1_2.b = b) AND ((t1_2.c)::text = (c)::text))
+         ->  Nested Loop
+               ->  Parallel Seq Scan on prt1_l_p3_p1 t1_4
+               ->  Materialize
          ->  Sample Scan on prt1_l_p3_p1 t2_4
                Sampling: system (t1_4.a) REPEATABLE (t1_4.b)
                Filter: ((t1_4.a = a) AND (t1_4.b = b) AND ((t1_4.c)::text = (c)::text))
    ->  Nested Loop
-         ->  Seq Scan on prt1_l_p3_p2 t1_5
+               ->  Parallel Seq Scan on prt1_l_p3_p2 t1_5
+               ->  Materialize
          ->  Sample Scan on prt1_l_p3_p2 t2_5
                Sampling: system (t1_5.a) REPEATABLE (t1_5.b)
                Filter: ((t1_5.a = a) AND (t1_5.b = b) AND ((t1_5.c)::text = (c)::text))
-(26 rows)
+(33 rows)
 
 -- partitionwise join with lateral reference in scan's restriction clauses
 EXPLAIN (COSTS OFF)