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
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 |