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

   
   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 20c1872a0da95dbee5cb407c3078f24909839444, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5436    5176    5205    5176
   q2   384     163     155     155
   q3   1470    1179    1148    1148
   q4   1093    815     780     780
   q5   3109    3063    3180    3063
   q6   223     133     135     133
   q7   959     530     530     530
   q8   2149    2184    2290    2184
   q9   6699    6651    6844    6651
   q10  3164    3085    3120    3085
   q11  344     216     204     204
   q12  387     239     231     231
   q13  4387    3638    3649    3638
   q14  250     233     225     225
   q15  585     540     528     528
   q16  465     397     397     397
   q17  1046    581     559     559
   q18  7092    6731    6830    6731
   q19  1644    1533    1490    1490
   q20  549     328     340     328
   q21  2864    2445    2449    2445
   q22  402     339     343     339
   Total cold run time: 44701 ms
   Total hot run time: 40020 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5134    5103    5153    5103
   q2   338     239     238     238
   q3   3390    3320    3322    3320
   q4   2157    2029    2036    2029
   q5   5960    5910    5897    5897
   q6   227     128     128     128
   q7   2385    1908    1911    1908
   q8   3545    3678    3659    3659
   q9   9000    8970    8963    8963
   q10  3871    3894    3911    3894
   q11  584     485     466     466
   q12  799     625     636     625
   q13  3882    3180    3190    3180
   q14  304     276     290     276
   q15  603     529     535     529
   q16  546     490     492     490
   q17  2040    1811    1831    1811
   q18  8737    8359    8594    8359
   q19  1738    1687    1730    1687
   q20  2254    2013    2000    2000
   q21  5743    5280    5279    5279
   q22  557     509     521     509
   Total cold run time: 63794 ms
   Total hot run time: 60350 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