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

From Ashutosh Bapat
Subject Re: A problem about partitionwise join
Date
Msg-id CAExHW5t6sXYM0Hx_22PPV7AjVFAwTDTxnycfLAc83rJnYVMWZQ@mail.gmail.com
Whole thread Raw
In response to Re: A problem about partitionwise join  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-hackers
>
> I think it would not work for outer joins if we only check
> exprs_known_equal() for equivalences. If the equi-join conditions
> involving pairs of matching partition keys are outer join quals
> mentioning nonnullable side rels, they would not exist in any EC
> according to the current EC infrastructure. So we still have to look
> through restrictlist.
>

When I wrote that function and even today, EC didn't accommodate outer
join equality conditions. If we can somehow do that,
have_partkey_equi_join() can be completely eliminated.

-- 
Best Wishes,
Ashutosh Bapat



pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [HACKERS] advanced partition matching algorithm forpartition-wise join
Next
From: Fujii Masao
Date:
Subject: Re: backup manifests