Re: A problem about partitionwise join - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: A problem about partitionwise join
Date
Msg-id CAPmGK1464r7bWQJVTYkJj7U=eAJXyjAtLDmfWjau65Gubf+MxQ@mail.gmail.com
Whole thread Raw
In response to Re: A problem about partitionwise join  (Richard Guo <riguo@pivotal.io>)
List pgsql-hackers
On Fri, Aug 30, 2019 at 12:15 PM Richard Guo <riguo@pivotal.io> wrote:
> On Fri, Aug 30, 2019 at 2:08 AM Etsuro Fujita <etsuro.fujita@gmail.com> wrote:
>> On Thu, Aug 29, 2019 at 6:45 PM Richard Guo <riguo@pivotal.io> wrote:
>> > Attached is a patch as an attempt to address this issue. The idea is
>> > quite straightforward. When building partition info for joinrel, we
>> > generate any possible EC-derived joinclauses of form 'outer_em =
>> > inner_em', which will be used together with the original restrictlist to
>> > check if there exists an equi-join condition for each pair of partition
>> > keys.

>> Could you add the patch to the
>> upcoming CF so that it doesn’t get lost?

> Added this patch: https://commitfest.postgresql.org/24/2266/

Thanks!

Best regards,
Etsuro Fujita



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index.
Next
From: Jeff Davis
Date:
Subject: Re: Memory-Bounded Hash Aggregation