postgres
diff --git a/‎src/backend/executor/execParallel.c
Lines changed: 0 additions & 21 deletions
Original file line number Diff line number Diff line change
@@ -465,28 +465,7 @@ select count(*) from bmscantest where a>1;
465 465 99999
466 466 (1 row)
467 467
468 --- test accumulation of stats for parallel node
469 468 reset enable_seqscan;
470 -alter table tenk2 set (parallel_workers = 0);
471 -explain (analyze, timing off, summary off, costs off)
472 - select count(*) from tenk1, tenk2 where tenk1.hundred > 1
473 - and tenk2.thousand=0;
474 - QUERY PLAN
475 ---------------------------------------------------------------------------
476 - Aggregate (actual rows=1 loops=1)
477 - -> Nested Loop (actual rows=98000 loops=1)
478 - -> Seq Scan on tenk2 (actual rows=10 loops=1)
479 - Filter: (thousand = 0)
480 - Rows Removed by Filter: 9990
481 - -> Gather (actual rows=9800 loops=10)
482 - Workers Planned: 4
483 - Workers Launched: 4
484 - -> Parallel Seq Scan on tenk1 (actual rows=1960 loops=50)
485 - Filter: (hundred > 1)
486 - Rows Removed by Filter: 40
487 -(11 rows)
488 -
489 -alter table tenk2 reset (parallel_workers);
490 469 reset enable_indexscan;
491 470 reset enable_hashjoin;
492 471 reset enable_mergejoin; b/‎src/backend/executor/execParallel.c
Lines changed: 0 additions & 21 deletions
Original file line number Diff line number Diff line change
@@ -465,28 +465,7 @@ select count(*) from bmscantest where a>1;
465 465 99999
466 466 (1 row)
467 467
468 --- test accumulation of stats for parallel node
469 468 reset enable_seqscan;
470 -alter table tenk2 set (parallel_workers = 0);
471 -explain (analyze, timing off, summary off, costs off)
472 - select count(*) from tenk1, tenk2 where tenk1.hundred > 1
473 - and tenk2.thousand=0;
474 - QUERY PLAN
475 ---------------------------------------------------------------------------
476 - Aggregate (actual rows=1 loops=1)
477 - -> Nested Loop (actual rows=98000 loops=1)
478 - -> Seq Scan on tenk2 (actual rows=10 loops=1)
479 - Filter: (thousand = 0)
480 - Rows Removed by Filter: 9990
481 - -> Gather (actual rows=9800 loops=10)
482 - Workers Planned: 4
483 - Workers Launched: 4
484 - -> Parallel Seq Scan on tenk1 (actual rows=1960 loops=50)
485 - Filter: (hundred > 1)
486 - Rows Removed by Filter: 40
487 -(11 rows)
488 -
489 -alter table tenk2 reset (parallel_workers);
490 469 reset enable_indexscan;
491 470 reset enable_hashjoin;
492 471 reset enable_mergejoin;
diff --git a/‎src/test/regress/sql/select_parallel.sql
Lines changed: 0 additions & 7 deletions b/‎src/test/regress/sql/select_parallel.sql
Lines changed: 0 additions & 7 deletions
@@ -465,28 +465,7 @@ select count(*) from bmscantest where a>1;
  99999
 (1 row)
 
--- test accumulation of stats for parallel node
 reset enable_seqscan;
-alter table tenk2 set (parallel_workers = 0);
-explain (analyze, timing off, summary off, costs off)
-	select count(*) from tenk1, tenk2 where tenk1.hundred > 1
-        and tenk2.thousand=0;
-                                QUERY PLAN                                
---------------------------------------------------------------------------
- Aggregate (actual rows=1 loops=1)
-   ->  Nested Loop (actual rows=98000 loops=1)
-               Filter: (thousand = 0)
-               Rows Removed by Filter: 9990
-         ->  Gather (actual rows=9800 loops=10)
-               Workers Planned: 4
-               Workers Launched: 4
-               ->  Parallel Seq Scan on tenk1 (actual rows=1960 loops=50)
-                     Filter: (hundred > 1)
-                     Rows Removed by Filter: 40
-(11 rows)
-
-alter table tenk2 reset (parallel_workers);
 reset enable_indexscan;
 reset enable_hashjoin;
 reset enable_mergejoin;
 
@@ -179,14 +179,7 @@ insert into bmscantest select r, 'fooooooooooooooooooooooooooooooooooooooooooooo
 create index i_bmtest ON bmscantest(a);
 select count(*) from bmscantest where a>1;
 
--- test accumulation of stats for parallel node
 reset enable_seqscan;
-alter table tenk2 set (parallel_workers = 0);
-explain (analyze, timing off, summary off, costs off)
-	select count(*) from tenk1, tenk2 where tenk1.hundred > 1
-        and tenk2.thousand=0;
-alter table tenk2 reset (parallel_workers);
-
 reset enable_indexscan;
 reset enable_hashjoin;
 reset enable_mergejoin;