Re: Removing unneeded self joins

> Generally I have the impression that we are not too keen on spending
> planning time on optimizing cases that can be trivially improved by
> rewriting the query.

Well in some cases they can't, when the query is not emitting redundant 
predicates by itself but they are added by something else like a view or a RLS 
policy.
Maybe it would be worth it to allow spending a bit more time planning for 
those cases ?

Regards,

--
Ronan Dunklau