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

   
   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 256a679b31220957b62081c8c34b1db489ab5071, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5493    5137    5142    5137
   q2   390     202     199     199
   q3   1461    1185    1174    1174
   q4   1064    823     850     823
   q5   3141    3229    3089    3089
   q6   227     135     134     134
   q7   980     567     530     530
   q8   2159    2291    2216    2216
   q9   6754    6685    6662    6662
   q10  3209    3145    3184    3145
   q11  354     228     232     228
   q12  391     245     247     245
   q13  4407    3679    3716    3679
   q14  251     219     213     213
   q15  624     571     578     571
   q16  455     397     422     397
   q17  1055    568     558     558
   q18  7068    6758    6730    6730
   q19  1651    1555    1512    1512
   q20  599     350     363     350
   q21  2959    2539    2465    2465
   q22  386     321     348     321
   Total cold run time: 45078 ms
   Total hot run time: 40378 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5112    5051    5094    5051
   q2   344     259     284     259
   q3   3373    3355    3328    3328
   q4   2178    1990    1990    1990
   q5   5950    5934    5925    5925
   q6   236     133     132     132
   q7   2397    1942    1965    1942
   q8   3588    3652    3696    3652
   q9   9068    9066    8999    8999
   q10  3872    3919    3930    3919
   q11  598     517     524     517
   q12  805     667     671     667
   q13  3893    3202    3220    3202
   q14  301     285     284     284
   q15  631     560     566     560
   q16  559     531     535     531
   q17  2005    1793    1795    1793
   q18  8779    8450    8376    8376
   q19  1766    1718    1731    1718
   q20  2282    2003    1990    1990
   q21  5706    5439    5419    5419
   q22  586     504     490     490
   Total cold run time: 64029 ms
   Total hot run time: 60744 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