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

   
   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 bd2c3b87ac9d92bd9b7ee2651c33c3f9e1014857, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5407    5174    5141    5141
   q2   392     162     157     157
   q3   1464    1151    1098    1098
   q4   1099    837     812     812
   q5   3138    3154    3146    3146
   q6   225     147     132     132
   q7   1005    572     537     537
   q8   2161    2278    2216    2216
   q9   6651    6713    6636    6636
   q10  3196    3110    3119    3110
   q11  339     231     206     206
   q12  393     231     230     230
   q13  4379    3703    3657    3657
   q14  250     224     219     219
   q15  610     558     545     545
   q16  456     428     401     401
   q17  1038    522     480     480
   q18  7075    6821    6824    6821
   q19  1638    1501    1464    1464
   q20  561     375     325     325
   q21  2920    2445    2491    2445
   q22  376     316     338     316
   Total cold run time: 44773 ms
   Total hot run time: 40094 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5097    5095    5069    5069
   q2   336     238     266     238
   q3   3350    3284    3288    3284
   q4   2170    2030    2031    2030
   q5   5946    5936    5944    5936
   q6   226     126     131     126
   q7   2361    1913    1919    1913
   q8   3585    3657    3682    3657
   q9   9122    9004    8949    8949
   q10  3879    3891    3913    3891
   q11  592     493     484     484
   q12  816     643     637     637
   q13  3915    3240    3216    3216
   q14  307     265     263     263
   q15  602     536     543     536
   q16  573     520     527     520
   q17  2052    1818    1821    1818
   q18  8743    8372    8403    8372
   q19  1736    1692    1682    1682
   q20  2290    1991    1977    1977
   q21  5777    5441    5287    5287
   q22  563     525     530     525
   Total cold run time: 64038 ms
   Total hot run time: 60410 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to