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

   
   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 0df0405a7f0ae7ac87ede3f9ec22c4ad1b5ddf12, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5573    5107    5107    5107
   q2   383     174     158     158
   q3   1471    1174    1158    1158
   q4   1088    905     798     798
   q5   3136    3155    3082    3082
   q6   221     132     132     132
   q7   967     563     515     515
   q8   2157    2231    2196    2196
   q9   6660    6692    6619    6619
   q10  3172    3085    3158    3085
   q11  339     221     237     221
   q12  383     233     234     233
   q13  4389    3615    3626    3615
   q14  244     216     209     209
   q15  579     537     541     537
   q16  443     394     391     391
   q17  1049    526     458     458
   q18  7074    6693    6764    6693
   q19  1650    1499    1565    1499
   q20  597     345     343     343
   q21  2894    2433    2533    2433
   q22  401     332     325     325
   Total cold run time: 44870 ms
   Total hot run time: 39807 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5107    5032    5039    5032
   q2   336     223     238     223
   q3   3376    3355    3314    3314
   q4   2150    2038    2029    2029
   q5   5962    5932    5928    5928
   q6   222     126     129     126
   q7   2397    1944    1957    1944
   q8   3566    3614    3672    3614
   q9   9031    8980    8986    8980
   q10  3886    3900    3955    3900
   q11  578     508     472     472
   q12  787     641     649     641
   q13  3886    3175    3156    3156
   q14  303     288     268     268
   q15  602     530     524     524
   q16  569     483     501     483
   q17  2052    1790    1814    1790
   q18  8799    8348    8374    8348
   q19  1740    1691    1700    1691
   q20  2270    2005    1954    1954
   q21  5683    5370    5341    5341
   q22  553     476     562     476
   Total cold run time: 63855 ms
   Total hot run time: 60234 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