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

   
   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 97c2065a1057aae137c81f01373420b47023102a, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5544    5175    5110    5110
   q2   389     193     160     160
   q3   1498    1190    1176    1176
   q4   1092    854     844     844
   q5   3107    3109    3026    3026
   q6   241     139     139     139
   q7   991     564     524     524
   q8   2172    2256    2211    2211
   q9   6746    6742    6701    6701
   q10  3155    3194    3120    3120
   q11  356     243     244     243
   q12  386     252     243     243
   q13  4384    3668    3638    3638
   q14  259     221     219     219
   q15  632     573     567     567
   q16  479     419     400     400
   q17  1059    609     580     580
   q18  7116    6838    6781    6781
   q19  1690    1606    1534    1534
   q20  575     352     364     352
   q21  2962    2534    2530    2530
   q22  410     318     333     318
   Total cold run time: 45243 ms
   Total hot run time: 40416 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5120    5113    5081    5081
   q2   337     251     256     251
   q3   3384    3347    3335    3335
   q4   2134    2006    2003    2003
   q5   5971    5957    5964    5957
   q6   234     132     135     132
   q7   2395    1893    1943    1893
   q8   3564    3661    3678    3661
   q9   9051    9048    8999    8999
   q10  3907    3921    3924    3921
   q11  604     502     499     499
   q12  798     636     661     636
   q13  3898    3213    3210    3210
   q14  295     274     275     274
   q15  632     554     560     554
   q16  550     510     528     510
   q17  2049    1823    1831    1823
   q18  8710    8296    8320    8296
   q19  1777    1764    1742    1742
   q20  2272    2014    1995    1995
   q21  5800    5399    5461    5399
   q22  565     530     491     491
   Total cold run time: 64047 ms
   Total hot run time: 60662 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