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

   
   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 0709b4df9b26ec1bd7a24db38c78678165aa2c9d, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5542    5185    5139    5139
   q2   390     165     163     163
   q3   1463    1260    1171    1171
   q4   1095    861     784     784
   q5   3095    3130    3104    3104
   q6   230     138     137     137
   q7   989     556     517     517
   q8   2165    2250    2313    2250
   q9   6676    6708    6665    6665
   q10  3200    3115    3146    3115
   q11  343     222     205     205
   q12  376     236     242     236
   q13  4392    3624    3693    3624
   q14  248     221     221     221
   q15  577     536     534     534
   q16  451     414     396     396
   q17  1040    539     499     499
   q18  7079    6746    6800    6746
   q19  1651    1541    1476    1476
   q20  612     347     318     318
   q21  2903    2510    2439    2439
   q22  397     335     321     321
   Total cold run time: 44914 ms
   Total hot run time: 40060 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5120    5054    5069    5054
   q2   342     235     242     235
   q3   3364    3381    3311    3311
   q4   2197    2040    2056    2040
   q5   5959    5942    5930    5930
   q6   222     128     131     128
   q7   2404    1906    1904    1904
   q8   3564    3651    3684    3651
   q9   9064    8969    9010    8969
   q10  3876    3907    3905    3905
   q11  580     475     488     475
   q12  802     659     649     649
   q13  3881    3169    3208    3169
   q14  316     277     262     262
   q15  589     534     519     519
   q16  560     518     488     488
   q17  2044    1856    1865    1856
   q18  8699    8304    8357    8304
   q19  1747    1714    1675    1675
   q20  2253    1978    1963    1963
   q21  5756    5308    5255    5255
   q22  590     501     486     486
   Total cold run time: 63929 ms
   Total hot run time: 60228 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