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

   
   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 986988e5273203b89b1c0260f40cc326c26f002d, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5475    5136    5161    5136
   q2   389     166     144     144
   q3   1472    1157    1156    1156
   q4   1074    779     788     779
   q5   3152    3113    3097    3097
   q6   220     131     135     131
   q7   972     549     536     536
   q8   2155    2276    2276    2276
   q9   6701    6720    6654    6654
   q10  3197    3134    3178    3134
   q11  354     233     221     221
   q12  370     235     225     225
   q13  4432    3622    3650    3622
   q14  251     220     212     212
   q15  567     550     529     529
   q16  462     386     398     386
   q17  1045    495     511     495
   q18  7106    6763    7642    6763
   q19  1644    1564    1439    1439
   q20  592     353     342     342
   q21  2857    2522    2461    2461
   q22  405     324     345     324
   Total cold run time: 44892 ms
   Total hot run time: 40062 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5099    5089    5038    5038
   q2   336     237     235     235
   q3   3349    3327    3318    3318
   q4   2145    2069    2067    2067
   q5   5943    5919    5928    5919
   q6   225     124     127     124
   q7   2364    1893    1956    1893
   q8   3561    3668    3666    3666
   q9   9048    8988    8985    8985
   q10  3849    3906    3901    3901
   q11  569     483     481     481
   q12  799     657     618     618
   q13  3885    3170    3184    3170
   q14  302     289     267     267
   q15  597     534     531     531
   q16  562     501     513     501
   q17  2039    1819    1801    1801
   q18  8726    8329    8365    8329
   q19  1742    1688    1697    1688
   q20  2275    1969    1970    1969
   q21  5763    5330    5396    5330
   q22  557     505     485     485
   Total cold run time: 63735 ms
   Total hot run time: 60316 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