asolimando opened a new issue, #27146:
URL: https://github.com/apache/datafusion/issues/27146

   ### Is your feature request related to a problem or challenge?
   
   #25790 added interval analysis to estimate filter selectivity on Decimal 
columns. On TPC-H Q18 this change made the plan use a much worse join order: 
the query took about 233 s and 22 GB of peak memory, compared with about 7 s 
and 4 GB before (#27108). #27145 reverts the change for the 56 release.
   
   ### Describe the solution you'd like
   
   Find out why the new estimate changes the Q18 join order. Then re-land 
#25790 with a TPC-H Q18 plan check, so that this regression cannot return.
   
   cc @shrivasshankar @devanbenz


-- 
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]

Reply via email to