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

   
   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 cbd00253f8bb3ff68198b87dca17c6ad547c99b5, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5505    5151    5222    5151
   q2   398     162     160     160
   q3   1446    1144    1089    1089
   q4   1084    873     803     803
   q5   3124    3046    3052    3046
   q6   223     144     128     128
   q7   997     565     517     517
   q8   2151    2181    2290    2181
   q9   6723    6650    6686    6650
   q10  3140    3142    3177    3142
   q11  349     223     220     220
   q12  384     231     233     231
   q13  4384    3650    3608    3608
   q14  251     224     214     214
   q15  589     545     537     537
   q16  465     400     406     400
   q17  1046    520     490     490
   q18  7100    6747    7790    6747
   q19  1644    1561    1623    1561
   q20  562     363     340     340
   q21  2879    2578    2490    2490
   q22  382     313     309     309
   Total cold run time: 44826 ms
   Total hot run time: 40014 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5097    5039    5042    5039
   q2   338     245     255     245
   q3   3391    3329    3271    3271
   q4   2148    2072    2033    2033
   q5   5936    5936    5886    5886
   q6   224     123     123     123
   q7   2373    1896    1940    1896
   q8   3551    3652    3664    3652
   q9   9023    8997    8942    8942
   q10  3869    3912    3906    3906
   q11  579     469     474     469
   q12  819     656     633     633
   q13  3868    3207    3161    3161
   q14  301     289     263     263
   q15  613     548     546     546
   q16  560     513     499     499
   q17  2057    1817    1812    1812
   q18  8736    8386    8429    8386
   q19  1748    1692    1678    1678
   q20  2288    1984    1984    1984
   q21  5641    5331    5325    5325
   q22  573     474     459     459
   Total cold run time: 63733 ms
   Total hot run time: 60208 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