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

   
   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 d2bd7ed582d9494a5f1c33f664060cf008cf7473, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5538    5157    5108    5108
   q2   389     168     160     160
   q3   1454    1176    1170    1170
   q4   1090    841     825     825
   q5   3179    3076    3091    3076
   q6   228     132     141     132
   q7   998     562     505     505
   q8   2145    2246    2275    2246
   q9   6697    6652    6642    6642
   q10  3213    3149    3114    3114
   q11  329     223     205     205
   q12  384     238     241     238
   q13  4389    3667    3641    3641
   q14  255     222     221     221
   q15  606     539     530     530
   q16  461     409     418     409
   q17  1042    467     566     467
   q18  7064    6876    6766    6766
   q19  1648    1507    1593    1507
   q20  580     340     317     317
   q21  2905    2483    2392    2392
   q22  387     319     353     319
   Total cold run time: 44981 ms
   Total hot run time: 39990 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5160    5135    5089    5089
   q2   334     225     255     225
   q3   3354    3315    3304    3304
   q4   2141    2044    2032    2032
   q5   5933    5932    5904    5904
   q6   225     125     123     123
   q7   2380    1913    1916    1913
   q8   3542    3662    3691    3662
   q9   9021    8955    8972    8955
   q10  3877    3934    3918    3918
   q11  570     477     480     477
   q12  788     644     662     644
   q13  3877    3194    3197    3194
   q14  303     265     286     265
   q15  605     559     539     539
   q16  567     498     515     498
   q17  2025    1810    1792    1792
   q18  8792    8319    8336    8319
   q19  1753    1694    1677    1677
   q20  2267    1985    1997    1985
   q21  5704    5273    5379    5273
   q22  571     516     496     496
   Total cold run time: 63789 ms
   Total hot run time: 60284 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