*** /Users/smagen/projects/postgresql/env/master/src/src/test/regress/expected/select_parallel.out 2018-08-10 17:36:18.000000000 +0300 --- /Users/smagen/projects/postgresql/env/master/src/src/test/regress/results/select_parallel.out 2018-08-30 17:12:33.000000000 +0300 *************** *** 21,32 **** Workers Planned: 3 -> Partial Aggregate -> Parallel Append - -> Parallel Seq Scan on d_star - -> Parallel Seq Scan on f_star - -> Parallel Seq Scan on e_star -> Parallel Seq Scan on b_star -> Parallel Seq Scan on c_star -> Parallel Seq Scan on a_star (11 rows) select round(avg(aa)), sum(aa) from a_star a1; --- 21,32 ---- Workers Planned: 3 -> Partial Aggregate -> Parallel Append -> Parallel Seq Scan on b_star -> Parallel Seq Scan on c_star -> Parallel Seq Scan on a_star + -> Parallel Seq Scan on e_star + -> Parallel Seq Scan on d_star + -> Parallel Seq Scan on f_star (11 rows) select round(avg(aa)), sum(aa) from a_star a1; *************** *** 49,58 **** -> Parallel Append -> Seq Scan on d_star -> Seq Scan on c_star - -> Parallel Seq Scan on f_star - -> Parallel Seq Scan on e_star -> Parallel Seq Scan on b_star -> Parallel Seq Scan on a_star (11 rows) select round(avg(aa)), sum(aa) from a_star a2; --- 49,58 ---- -> Parallel Append -> Seq Scan on d_star -> Seq Scan on c_star -> Parallel Seq Scan on b_star -> Parallel Seq Scan on a_star + -> Parallel Seq Scan on e_star + -> Parallel Seq Scan on f_star (11 rows) select round(avg(aa)), sum(aa) from a_star a2; ====================================================================== *** /Users/smagen/projects/postgresql/env/master/src/src/test/regress/expected/partition_join.out 2018-08-14 17:03:49.000000000 +0300 --- /Users/smagen/projects/postgresql/env/master/src/src/test/regress/results/partition_join.out 2018-08-30 17:12:41.000000000 +0300 *************** *** 1793,1811 **** -- partitionwise join can not be applied if the partition ranges differ EXPLAIN (COSTS OFF) SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt4_n t2 WHERE t1.a = t2.a; ! QUERY PLAN ! ---------------------------------------------- Hash Join ! Hash Cond: (t1.a = t2.a) -> Append ! -> Seq Scan on prt1_p1 t1 ! -> Seq Scan on prt1_p2 t1_1 ! -> Seq Scan on prt1_p3 t1_2 -> Hash -> Append ! -> Seq Scan on prt4_n_p1 t2 ! -> Seq Scan on prt4_n_p2 t2_1 ! -> Seq Scan on prt4_n_p3 t2_2 (11 rows) EXPLAIN (COSTS OFF) --- 1793,1811 ---- -- partitionwise join can not be applied if the partition ranges differ EXPLAIN (COSTS OFF) SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt4_n t2 WHERE t1.a = t2.a; ! QUERY PLAN ! -------------------------------------------- Hash Join ! Hash Cond: (t2.a = t1.a) -> Append ! -> Seq Scan on prt4_n_p1 t2 ! -> Seq Scan on prt4_n_p2 t2_1 ! -> Seq Scan on prt4_n_p3 t2_2 -> Hash -> Append ! -> Seq Scan on prt1_p1 t1 ! -> Seq Scan on prt1_p2 t1_1 ! -> Seq Scan on prt1_p3 t1_2 (11 rows) EXPLAIN (COSTS OFF) ======================================================================