Re: Removing unneeded self joins - Mailing list pgsql-hackers

From Ronan Dunklau
Subject Re: Removing unneeded self joins
Date
Msg-id 4911774.fQZKmtWmdp@aivenronan
Whole thread Raw
In response to Re: Removing unneeded self joins  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Removing unneeded self joins  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
> 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





pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: RFC: Logging plan of the running query
Next
From: Guillaume Lelarge
Date:
Subject: Re: New committers: Daniel Gustafsson and John Naylor