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

   
   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 c3b42ace8a8c17a5c8b37ac0e530b44e33092ada, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5516    5131    5155    5131
   q2   394     172     160     160
   q3   1478    1175    1142    1142
   q4   1097    860     859     859
   q5   3132    3107    3126    3107
   q6   224     138     137     137
   q7   998     546     510     510
   q8   2147    2209    2238    2209
   q9   6663    6652    6678    6652
   q10  3159    3143    3141    3141
   q11  358     234     221     221
   q12  387     232     234     232
   q13  4367    3681    3647    3647
   q14  253     223     208     208
   q15  603     557     529     529
   q16  474     417     390     390
   q17  1044    545     536     536
   q18  7131    6685    7109    6685
   q19  1627    1505    1433    1433
   q20  562     366     360     360
   q21  2939    2461    2387    2387
   q22  412     338     344     338
   Total cold run time: 44965 ms
   Total hot run time: 40014 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5086    5081    5043    5043
   q2   356     243     261     243
   q3   3387    3340    3302    3302
   q4   2126    2031    2017    2017
   q5   5955    5946    5928    5928
   q6   232     125     124     124
   q7   2382    1943    1971    1943
   q8   3559    3655    3702    3655
   q9   8969    8960    8946    8946
   q10  3875    3886    3901    3886
   q11  601     471     479     471
   q12  825     685     657     657
   q13  3867    3217    3206    3206
   q14  305     272     289     272
   q15  601     531     542     531
   q16  558     525     543     525
   q17  2021    1809    1791    1791
   q18  8817    8340    8549    8340
   q19  1736    1685    1671    1671
   q20  2276    2033    1975    1975
   q21  5710    5296    5358    5296
   q22  580     524     476     476
   Total cold run time: 63824 ms
   Total hot run time: 60298 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