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

From Etsuro Fujita
Subject Re: A problem about partitionwise join
Date
Msg-id CAPmGK15cnjECPmncz=_JkaaEXnADrvhBYBkB2nCUV8phvc7WhA@mail.gmail.com
Whole thread Raw
In response to Re: A problem about partitionwise join  (Etsuro Fujita <etsuro.fujita@gmail.com>)
Responses Re: A problem about partitionwise join
List pgsql-hackers
Hi Richard,

On Fri, Aug 30, 2019 at 3: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.
>
> Will review.

I've just started reviewing this patch.  One comment I have for now
is: this is categorized into Bug Fixes, but we have a workaround at
least to the regression test case in the patch (ie, just reorder join
clauses), so this seems to me more like an improvement than a bug fix.

Sorry for the delay.

Best regards,
Etsuro Fujita



pgsql-hackers by date:

Previous
From: Antonin Houska
Date:
Subject: Re: Attempt to consolidate reading of XLOG page
Next
From: John Naylor
Date:
Subject: Re: benchmarking Flex practices