On 2019/05/14 13:23, Amit Langote wrote: > Tom > strongly objected to that idea saying that such join paths are kind of > silly [1], even outside the context of partitionwise join. He suggested > that we abandon partitionwise join in such cases, because having to build > a dummy base relation for pruned partitions only to generate silly-looking > paths would be an ugly kludge.
I forgot to mention that he even committed a patch to disable partitionwise joins in such cases, which was also applied to v11 branch. https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d70c147fa217c4bae32ac1afb86ab42d98b36fdf Note that there were also other reasons for committing, beside what I described in my previous email. Thanks, Amit
