Re: Allow parallel DISTINCT

From: Zhihong Yu <zyu(at)yugabyte(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Allow parallel DISTINCT
Date: 2021-08-17 14:47:40
Message-ID: CALNJ-vRLd63reKpo2fgeenV+DuoXj-bdT36upL3brx8c+3DEKw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Aug 17, 2021 at 3:59 AM David Rowley <dgrowleyml(at)gmail(dot)com> wrote:

> On Tue, 17 Aug 2021 at 20:07, Zhihong Yu <zyu(at)yugabyte(dot)com> wrote:
> > Can you attach updated patch so that we know more detail about the two
> new functions; create_final_distinct_paths and
> > create_partial_distinct_paths ?
>
> Must've fallen off in transit :)
>
> David
>
Hi,
Since create_partial_distinct_paths() calls create_final_distinct_paths(),
I wonder if numDistinctRows can be passed to create_final_distinct_paths()
so that the latter doesn't need to call estimate_num_groups().

Cheers

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhihong Yu 2021-08-17 15:12:21 Re: [PATCH] Allow multiple recursive self-references
Previous Message Peter Eisentraut 2021-08-17 14:36:45 Re: automatically generating node support functions