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

   
   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 9ed83aa5b98e1faa6725193d7d2b6a16be20cded, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5552    5174    5192    5174
   q2   382     168     158     158
   q3   1478    1215    1159    1159
   q4   1090    844     805     805
   q5   3133    3169    3158    3158
   q6   227     136     137     136
   q7   981     549     503     503
   q8   2166    2237    2303    2237
   q9   6723    6723    6683    6683
   q10  3221    3117    3143    3117
   q11  338     230     217     217
   q12  386     239     246     239
   q13  4377    3650    3626    3626
   q14  249     228     220     220
   q15  587     554     533     533
   q16  452     407     400     400
   q17  1039    470     513     470
   q18  7095    6807    6792    6792
   q19  1653    1570    1631    1570
   q20  606     362     331     331
   q21  2931    2584    2561    2561
   q22  404     315     322     315
   Total cold run time: 45070 ms
   Total hot run time: 40404 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5141    5086    5161    5086
   q2   337     233     243     233
   q3   3382    3342    3342    3342
   q4   2162    2084    2067    2067
   q5   5968    5954    5924    5924
   q6   224     131     128     128
   q7   2392    1937    1969    1937
   q8   3588    3682    3686    3682
   q9   9113    9014    9041    9014
   q10  3874    3902    3914    3902
   q11  588     485     481     481
   q12  821     644     636     636
   q13  3875    3222    3173    3173
   q14  284     270     260     260
   q15  589     552     528     528
   q16  572     492     535     492
   q17  2024    1857    1834    1834
   q18  8794    8400    8316    8316
   q19  1761    1688    1687    1687
   q20  2275    1992    1950    1950
   q21  5778    5444    5376    5376
   q22  589     549     482     482
   Total cold run time: 64131 ms
   Total hot run time: 60530 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