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

   
   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 57432ebd2ecc4c7d9567246c22c1fccaf74f03c9, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5449    5185    5151    5151
   q2   390     165     159     159
   q3   1456    1162    1200    1162
   q4   1087    802     814     802
   q5   3090    2967    3077    2967
   q6   224     137     139     137
   q7   957     550     526     526
   q8   2144    2218    2218    2218
   q9   6725    6677    6675    6675
   q10  3162    3093    3130    3093
   q11  351     228     225     225
   q12  391     236     242     236
   q13  4455    3625    3670    3625
   q14  252     219     223     219
   q15  606     570     559     559
   q16  465     422     408     408
   q17  1044    554     516     516
   q18  7044    6802    6774    6774
   q19  1638    1503    1598    1503
   q20  558     341     336     336
   q21  2889    2448    2543    2448
   q22  408     334     323     323
   Total cold run time: 44785 ms
   Total hot run time: 40062 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5190    5173    5144    5144
   q2   342     253     241     241
   q3   3351    3326    3324    3324
   q4   2138    2026    2045    2026
   q5   5980    5960    5928    5928
   q6   227     127     124     124
   q7   2402    1945    1908    1908
   q8   3602    3659    3658    3658
   q9   9120    9030    9003    9003
   q10  3864    3963    3948    3948
   q11  576     481     484     481
   q12  804     640     667     640
   q13  3900    3195    3192    3192
   q14  302     269     275     269
   q15  624     552     549     549
   q16  593     540     486     486
   q17  2039    1863    1813    1813
   q18  8760    8379    8495    8379
   q19  1744    1682    1697    1682
   q20  2283    1994    1988    1988
   q21  5826    5413    5357    5357
   q22  570     468     492     468
   Total cold run time: 64237 ms
   Total hot run time: 60608 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