Re: Allow parallel DISTINCT
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Zhihong Yu <zyu@yugabyte.com>,
PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2021-08-22T13:58:03Z
Lists: pgsql-hackers
David Rowley <dgrowleyml@gmail.com> writes:
> I've pushed this to master now.
... and the buildfarm is pushing back, eg
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hoverfly&dt=2021-08-22%2011%3A31%3A45
diff -U3 /scratch/nm/farm/xlc64v16/HEAD/pgsql.build/src/test/regress/expected/select_distinct.out /scratch/nm/farm/xlc64v16/HEAD/pgsql.build/src/test/regress/results/select_distinct.out
--- /scratch/nm/farm/xlc64v16/HEAD/pgsql.build/src/test/regress/expected/select_distinct.out 2021-08-22 11:26:22.000000000 +0000
+++ /scratch/nm/farm/xlc64v16/HEAD/pgsql.build/src/test/regress/results/select_distinct.out 2021-08-22 11:38:43.000000000 +0000
@@ -223,7 +223,7 @@
-> Sort
Sort Key: four
-> Gather
- Workers Planned: 2
+ Workers Planned: 5
-> HashAggregate
Group Key: four
-> Parallel Seq Scan on tenk1
@@ -270,7 +270,7 @@
-> Sort
Sort Key: (distinct_func(1))
-> Gather
- Workers Planned: 2
+ Workers Planned: 5
-> Parallel Seq Scan on tenk1
(6 rows)
regards, tom lane
Commits
-
Allow parallel DISTINCT
- 22c4e88ebff4 15.0 landed