Re: Allow parallel DISTINCT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Zhihong Yu <zyu(at)yugabyte(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Allow parallel DISTINCT
Date: 2021-08-22 13:58:03
Message-ID: 3491.1629640683@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Rowley <dgrowleyml(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2021-08-22 14:35:46 Re: Allow parallel DISTINCT
Previous Message Julien Rouhaud 2021-08-22 13:29:01 Re: Mark all GUC variable as PGDLLIMPORT