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

   
   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 2147b7b17f5a70dc9f5ed51ad5e2baf367b9ce16, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5495    5171    5100    5100
   q2   382     172     158     158
   q3   1451    1115    1122    1115
   q4   1087    866     820     820
   q5   3147    3150    3056    3056
   q6   222     132     134     132
   q7   969     553     520     520
   q8   2169    2263    2253    2253
   q9   6722    6659    6653    6653
   q10  3193    3125    3092    3092
   q11  336     217     219     217
   q12  387     236     233     233
   q13  4383    3668    3624    3624
   q14  259     215     214     214
   q15  576     529     526     526
   q16  457     402     406     402
   q17  1032    494     491     491
   q18  7109    6726    6796    6726
   q19  1644    1535    1596    1535
   q20  598     326     328     326
   q21  2877    2439    2436    2436
   q22  383     322     341     322
   Total cold run time: 44878 ms
   Total hot run time: 39951 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5156    5083    5087    5083
   q2   345     233     236     233
   q3   3352    3348    3300    3300
   q4   2152    2039    2029    2029
   q5   5928    5912    5904    5904
   q6   227     123     128     123
   q7   2396    1927    1956    1927
   q8   3583    3641    3690    3641
   q9   9035    8979    8930    8930
   q10  3878    3897    3901    3897
   q11  579     493     473     473
   q12  796     634     640     634
   q13  3861    3187    3198    3187
   q14  297     264     290     264
   q15  593     532     533     532
   q16  566     516     508     508
   q17  2020    1814    1850    1814
   q18  8770    8332    8341    8332
   q19  1738    1717    1665    1665
   q20  2272    1988    1955    1955
   q21  5686    5393    5345    5345
   q22  560     514     485     485
   Total cold run time: 63790 ms
   Total hot run time: 60261 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