doris-robot commented on PR #29403:
URL: https://github.com/apache/doris/pull/29403#issuecomment-1876694342

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G', run with 
scripts in https://github.com/apache/doris/tree/master/tools/tpch-tools
   ```
   Tpch sf100 test result on commit 54a149b6a7edc9e1affc9e6dc16f3fb2f63ff6c2, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5483    5094    5111    5094
   q2   395     160     162     160
   q3   1441    1134    1178    1134
   q4   1105    786     817     786
   q5   3139    3099    3099    3099
   q6   226     137     136     136
   q7   976     566     519     519
   q8   2167    2290    2278    2278
   q9   6661    6642    6618    6618
   q10  3197    3104    3088    3088
   q11  338     226     212     212
   q12  381     230     240     230
   q13  4402    3617    3651    3617
   q14  253     202     214     202
   q15  581     535     526     526
   q16  455     380     419     380
   q17  1048    567     623     567
   q18  7096    6756    6778    6756
   q19  1641    1518    1548    1518
   q20  556     349     332     332
   q21  2869    2495    2443    2443
   q22  401     332     333     332
   Total cold run time: 44811 ms
   Total hot run time: 40027 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5167    5079    5051    5051
   q2   338     242     244     242
   q3   3355    3331    3327    3327
   q4   2173    2041    2065    2041
   q5   5978    5911    5906    5906
   q6   225     128     128     128
   q7   2367    1923    1965    1923
   q8   3574    3667    3650    3650
   q9   9016    8978    8991    8978
   q10  3844    3899    3920    3899
   q11  579     474     484     474
   q12  804     650     633     633
   q13  3882    3182    3186    3182
   q14  304     280     265     265
   q15  593     529     520     520
   q16  567     500     508     500
   q17  2023    1818    1798    1798
   q18  8729    8443    8430    8430
   q19  1763    1665    1674    1665
   q20  2269    1984    1953    1953
   q21  5746    5345    5323    5323
   q22  567     564     514     514
   Total cold run time: 63863 ms
   Total hot run time: 60402 ms
   ```
   


-- 
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: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to