Justin Pryzby <pry...@telsasoft.com> writes: > On Fri, Oct 11, 2019 at 10:48:37AM -0400, Tom Lane wrote: >> Could you provide a self-contained test case please?
> [ test case ] Oh, this is the same issue Amit described in https://www.postgresql.org/message-id/flat/CA%2BHiwqG2WVUGmLJqtR0tPFhniO%3DH%3D9qQ%2BZ3L_ZC%2BY3-EVQHFGg%40mail.gmail.com namely that we're not generating EquivalenceClass members corresponding to sub-joins of a partitionwise join. Are you interested in helping to test the patches proposed there? regards, tom lane