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

   
   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 94d384f69786976f716bfc28bb3b1e98810abc3c, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5490    5135    5139    5135
   q2   388     186     205     186
   q3   1454    1212    1198    1198
   q4   1095    798     779     779
   q5   3108    3005    3107    3005
   q6   220     136     144     136
   q7   963     541     554     541
   q8   2182    2301    2254    2254
   q9   6727    6695    6659    6659
   q10  3190    3164    3122    3122
   q11  353     215     216     215
   q12  389     239     239     239
   q13  4386    3639    3644    3639
   q14  248     214     215     214
   q15  582     524     532     524
   q16  470     414     388     388
   q17  1058    536     551     536
   q18  7087    6724    6782    6724
   q19  1643    1517    1421    1421
   q20  562     351     327     327
   q21  2904    2552    2527    2527
   q22  385     314     315     314
   Total cold run time: 44884 ms
   Total hot run time: 40083 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5171    5111    5093    5093
   q2   334     242     240     240
   q3   3369    3338    3341    3338
   q4   2173    2093    2078    2078
   q5   5978    5964    5989    5964
   q6   224     129     133     129
   q7   2408    1961    1965    1961
   q8   3589    3670    3704    3670
   q9   9090    9042    9040    9040
   q10  3875    3877    3937    3877
   q11  569     473     482     473
   q12  816     639     646     639
   q13  3899    3205    3235    3205
   q14  303     270     273     270
   q15  589     527     525     525
   q16  555     515     495     495
   q17  2018    1853    1816    1816
   q18  8779    8425    8295    8295
   q19  1743    1724    1686    1686
   q20  2275    1983    1961    1961
   q21  5809    5316    5371    5316
   q22  550     511     492     492
   Total cold run time: 64116 ms
   Total hot run time: 60563 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