f foo
> is empty then postgres is required to return no results, regardless of
> how many rows are in bar. This is why it can ignore the table in the
> left join
>
> — David
>
> > On 14 May 2020, at 1:44 pm, Matthew Nelson wrote:
> >
> > I noticed something pec
I noticed something peculiar while optimizing complex views today. The query
planner does not skip inner joins that, to my understanding, can have no impact
on the result. Am I missing a situation where these joins could impact the
result?
The following demonstrates the problem without the comp
