Unstable number of workers in select_parallel test on spurfowl

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Unstable number of workers in select_parallel test on spurfowl
Date: 2018-04-05 04:04:22
Message-ID: CAEepm=0eSFRtSj4j7NX20neGePa5izzawwrRKwzUMyBoAfg0Jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=spurfowl&dt=2018-04-05%2003%3A22%3A05

*** /home/pgbuild/buildfarm/HEAD/pgsql.build/src/test/regress/expected/select_parallel.out
2018-04-04 23:22:07.297108347 -0400
--- /home/pgbuild/buildfarm/HEAD/pgsql.build/src/test/regress/results/select_parallel.out
2018-04-04 23:24:11.709955623 -0400
***************
*** 103,109 ****
-----------------------------------------------------
Finalize Aggregate
-> Gather
! Workers Planned: 1
-> Partial Aggregate
-> Append
-> Parallel Seq Scan on a_star
--- 103,109 ----
-----------------------------------------------------
Finalize Aggregate
-> Gather
! Workers Planned: 3
-> Partial Aggregate
-> Append
-> Parallel Seq Scan on a_star

This is the query like this:

-- Disable Parallel Append
alter table a_star reset (parallel_workers);
alter table b_star reset (parallel_workers);
alter table c_star reset (parallel_workers);
alter table d_star reset (parallel_workers);
alter table e_star reset (parallel_workers);
alter table f_star reset (parallel_workers);
set enable_parallel_append to off;
explain (costs off)
select round(avg(aa)), sum(aa) from a_star;

I don't see why...

--
Thomas Munro
http://www.enterprisedb.com

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-04-05 04:10:03 Re: WIP: a way forward on bootstrap data
Previous Message David Rowley 2018-04-05 03:41:30 Re: Parallel Aggregates for string_agg and array_agg