On Tue, May 14, 2019 at 12:24 AM Amit Langote <langote_amit...@lab.ntt.co.jp> wrote: > He did mention that cases where the nullable side is provably empty can be > handled by simply returning the path of the non-nullable side with > suitable projection path added on top to emit NULLs for the columns of the > nullable-side. If we teach populate_joinrel_with_paths() and underlings > about that, then we can allow partitionwise join even in the case where > the nullable side has some partitions missing.
Yes, I think that would be a good approach to pursue. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
