findepi commented on issue #10048: URL: https://github.com/apache/datafusion/issues/10048#issuecomment-2541925589
> Summarizing: Postgres appears to plan this type of query as a NestedLoops join: PostgreSQL is able to decorrelate some queries, but isn't necessarily the best at it (at least last time i checked some ... few years ago when adding correlated IN support to Trino). > I think we would need a (new) type of JoinExec that actually does run the outer query (aka unnest(t1.c1) for each input row of t1) Or have Unnest relational operator do this. This is how Trino does this. Because it doesn't support "join operator re-evaluates the right input", it has to model things differently, which happens to be more performant (as long as you are able to decorrelate). -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
