starocean999 commented on PR #8745: URL: https://github.com/apache/incubator-doris/pull/8745#issuecomment-1091252539
> The test results on SSB and TPC-H under different strategies can be given: > > * initially > > * only scan node has conjunct (optional) > > * scan and agg and exchange node has conjunct > > * all nodes have conjunct <p>I tested using TPCH 3G data based on current code. CPU: 6 core 12 threads * 1, memory: 16G. the policy impact 7 queries more or less</p> <div class="table-wrap"> runtime filter remove | q8 | q9 | q10 | q11 | q17 | q18 | q21 -- | -- | -- | -- | -- | -- | -- | -- OFF | 6.76s | 63.27s | 2.27s | 0.39s | 3.36s | 2.4s | 5.27s ON | 6.75s | 61.12s | 2.25s | 0.33s | 3.02s | 2.1s | 4.72s </div> -- 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]
