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

   
   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 23dacc3137ab141596e599396d266d3aed979cdd, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5455    5063    5222    5063
   q2   393     162     158     158
   q3   1494    1183    1159    1159
   q4   1094    825     832     825
   q5   3138    3128    3139    3128
   q6   223     141     130     130
   q7   985     560     527     527
   q8   2162    2278    2246    2246
   q9   6703    6653    6641    6641
   q10  3171    3186    3103    3103
   q11  354     217     215     215
   q12  378     238     231     231
   q13  4406    3641    3626    3626
   q14  256     225     213     213
   q15  608     550     546     546
   q16  480     412     418     412
   q17  1043    541     571     541
   q18  7054    6768    6772    6768
   q19  1645    1544    1448    1448
   q20  606     347     328     328
   q21  2861    2534    2574    2534
   q22  394     331     317     317
   Total cold run time: 44903 ms
   Total hot run time: 40159 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5165    5092    5055    5055
   q2   344     241     251     241
   q3   3357    3327    3283    3283
   q4   2160    2054    2046    2046
   q5   5940    5914    5933    5914
   q6   230     124     125     124
   q7   2373    2003    1923    1923
   q8   3541    3645    3664    3645
   q9   9122    9006    8969    8969
   q10  3867    3891    3902    3891
   q11  580     490     497     490
   q12  806     639     644     639
   q13  3904    3191    3191    3191
   q14  306     281     294     281
   q15  601     555     545     545
   q16  590     511     503     503
   q17  2048    1819    1831    1819
   q18  8811    8385    8727    8385
   q19  1737    1660    1639    1639
   q20  2289    1992    1965    1965
   q21  5669    5301    5321    5301
   q22  553     499     527     499
   Total cold run time: 63993 ms
   Total hot run time: 60348 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