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

   
   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 b76691952deeb32a1b31706f20d84d4b88522338, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5460    5151    5114    5114
   q2   384     172     150     150
   q3   1479    1235    1218    1218
   q4   1079    855     843     843
   q5   3129    3067    3058    3058
   q6   228     129     128     128
   q7   994     555     542     542
   q8   2163    2261    2219    2219
   q9   6722    6685    6636    6636
   q10  3150    3125    3062    3062
   q11  356     221     221     221
   q12  381     240     231     231
   q13  4423    3621    3666    3621
   q14  261     211     219     211
   q15  600     554     550     550
   q16  463     398     400     398
   q17  1046    592     509     509
   q18  7044    6732    6736    6732
   q19  1651    1559    1557    1557
   q20  570     346     336     336
   q21  2919    2446    2468    2446
   q22  404     324     338     324
   Total cold run time: 44906 ms
   Total hot run time: 40106 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5151    5070    5040    5040
   q2   328     249     272     249
   q3   3369    3325    3328    3325
   q4   2131    2016    2046    2016
   q5   5958    5928    5923    5923
   q6   226     124     128     124
   q7   2377    1908    1932    1908
   q8   3543    3663    3703    3663
   q9   8995    8956    9008    8956
   q10  3878    3946    3903    3903
   q11  586     489     484     484
   q12  814     697     647     647
   q13  3899    3236    3212    3212
   q14  300     262     286     262
   q15  606     536     553     536
   q16  556     518     512     512
   q17  2032    1837    1841    1837
   q18  8715    8356    8437    8356
   q19  1741    1710    1721    1710
   q20  2273    2006    1998    1998
   q21  5657    5353    5349    5349
   q22  569     538     505     505
   Total cold run time: 63704 ms
   Total hot run time: 60515 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