On Fri, Aug 30, 2019 at 12:15 PM Richard Guo <ri...@pivotal.io> wrote: > On Fri, Aug 30, 2019 at 2:08 AM Etsuro Fujita <etsuro.fuj...@gmail.com> wrote: >> On Thu, Aug 29, 2019 at 6:45 PM Richard Guo <ri...@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
