Hello Richard, On Wed, Sep 4, 2019 at 4:30 PM Richard Guo <ri...@pivotal.io> wrote: > > Hi Amit, > > On Wed, Sep 4, 2019 at 10:01 AM Amit Langote <amitlangot...@gmail.com> wrote: >> >> Fujita-san, >> >> To avoid losing track of this, I've added this to November CF. >> >> https://commitfest.postgresql.org/25/2278/ >> >> I know there is one more patch beside the partitionwise join fix, but >> I've set the title to suggest that this is related mainly to >> partitionwise joins. > > > Thank you for working on this. Currently partitionwise join does not > take COALESCE expr into consideration when matching to partition keys. > This is a problem. > > BTW, a rebase is needed for the patch set.
Thanks a lot for looking at this. I tried rebasing today and found that adopting this patch to the following recent commit to equivalence processing code would take some time that I don't currently have. commit 3373c7155350cf6fcd51dd090f29e1332901e329 Author: David Rowley <drow...@postgresql.org> Date: Sun Jul 21 17:30:58 2019 +1200 Speed up finding EquivalenceClasses for a given set of rels I will come back to this in a couple of weeks, along with addressing your other comments. Thanks, Amit