On Mon, 23 Sept 2024 at 00:55, PG Bug reporting form
<noreply(at)postgresql(dot)org> wrote:
> Postgres 15 is able to nicely remove all the joins and gives a nice tidy
> query plan:
> ```
> Seq Scan on origin o (cost=0.00..16.50 rows=650 width=32)
> ```
>
> Postgres 16 (and 17rc1) on the other hand are giving me this query plan
> instead:
> ```
> Hash Left Join (cost=24.62..42.84 rows=650 width=32)
Thanks for the report.
It looks like the first bad commit is acc5821e4d (Further fixes in
qual nullingrel adjustment for outer join commutation)
I doubt breaking this was an intended change of the nullable Var work.
Tom can likely confirm.
David