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

   
   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 35368ab92d8c4f0e60e3e1c81179bc97e2b7a46b, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5399    5206    5111    5111
   q2   386     165     158     158
   q3   1480    1159    1114    1114
   q4   1080    789     790     789
   q5   3157    3132    3192    3132
   q6   220     134     134     134
   q7   977     542     503     503
   q8   2180    2309    2223    2223
   q9   6710    6673    6687    6673
   q10  3198    3104    3175    3104
   q11  356     218     234     218
   q12  385     235     242     235
   q13  4409    3630    3615    3615
   q14  249     223     212     212
   q15  578     534     539     534
   q16  448     416     424     416
   q17  1054    566     526     526
   q18  7208    6725    7757    6725
   q19  1652    1580    1405    1405
   q20  549     316     342     316
   q21  2917    2505    2488    2488
   q22  399     309     339     309
   Total cold run time: 44991 ms
   Total hot run time: 39940 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5104    5085    5096    5085
   q2   336     230     238     230
   q3   3363    3350    3329    3329
   q4   2140    2067    2017    2017
   q5   5945    5951    5961    5951
   q6   225     124     127     124
   q7   2384    1919    1909    1909
   q8   3598    3658    3680    3658
   q9   9066    9040    8964    8964
   q10  3878    3912    3937    3912
   q11  582     487     463     463
   q12  817     623     630     623
   q13  3890    3202    3204    3202
   q14  298     270     266     266
   q15  584     537     521     521
   q16  546     493     469     469
   q17  2037    1832    1810    1810
   q18  8741    8334    8294    8294
   q19  1759    1725    1722    1722
   q20  2279    1976    1968    1968
   q21  5680    5319    5310    5310
   q22  588     489     479     479
   Total cold run time: 63840 ms
   Total hot run time: 60306 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