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

   
   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 c9e4f260570609c0c6a9b69fbe39a2f3e3cde19d, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5527    5220    5132    5132
   q2   388     157     159     157
   q3   1467    1157    1088    1088
   q4   1086    857     802     802
   q5   3100    3135    3063    3063
   q6   223     133     139     133
   q7   1018    574     496     496
   q8   2147    2220    2230    2220
   q9   6638    6655    6633    6633
   q10  3142    3133    3152    3133
   q11  335     232     212     212
   q12  384     233     228     228
   q13  4391    3622    3628    3622
   q14  248     219     223     219
   q15  624     556     544     544
   q16  455     390     433     390
   q17  1039    518     462     462
   q18  7091    6713    6732    6713
   q19  1661    1538    1468    1468
   q20  586     331     333     331
   q21  2848    2496    2480    2480
   q22  383     346     311     311
   Total cold run time: 44781 ms
   Total hot run time: 39837 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5187    5103    5159    5103
   q2   332     235     250     235
   q3   3365    3336    3294    3294
   q4   2110    2019    2050    2019
   q5   5970    5924    5917    5917
   q6   223     126     128     126
   q7   2344    1888    1896    1888
   q8   3556    3679    3689    3679
   q9   9047    8932    8971    8932
   q10  3861    3904    3910    3904
   q11  567     489     487     487
   q12  810     634     665     634
   q13  3875    3177    3180    3177
   q14  294     275     274     274
   q15  606     537     529     529
   q16  570     519     490     490
   q17  1995    1789    1892    1789
   q18  8747    8334    8371    8334
   q19  1738    1697    1681    1681
   q20  2314    1997    1995    1995
   q21  5675    5284    5344    5284
   q22  593     495     521     495
   Total cold run time: 63779 ms
   Total hot run time: 60266 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: [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