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

   
   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 f08124af3acd59bfc66a44c286f7267fa2e1c80a, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5516    5205    5203    5203
   q2   391     166     156     156
   q3   1471    1185    1237    1185
   q4   1112    908     804     804
   q5   3154    3079    3151    3079
   q6   225     137     140     137
   q7   1003    555     496     496
   q8   2164    2223    2200    2200
   q9   6751    6723    6653    6653
   q10  3157    3137    3228    3137
   q11  346     231     209     209
   q12  386     238     243     238
   q13  4402    3751    3678    3678
   q14  250     223     228     223
   q15  607     546     537     537
   q16  451     419     427     419
   q17  1049    527     503     503
   q18  7124    6754    6823    6754
   q19  1655    1549    1515    1515
   q20  585     348     360     348
   q21  2924    2442    2484    2442
   q22  400     337     328     328
   Total cold run time: 45123 ms
   Total hot run time: 40244 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5164    5196    5122    5122
   q2   341     247     271     247
   q3   3376    3339    3321    3321
   q4   2160    2025    2033    2025
   q5   5938    5926    5931    5926
   q6   232     129     129     129
   q7   2359    1977    1902    1902
   q8   3591    3685    3704    3685
   q9   9068    9079    9101    9079
   q10  3883    3928    3931    3928
   q11  611     501     487     487
   q12  812     645     665     645
   q13  3912    3247    3237    3237
   q14  304     292     287     287
   q15  622     541     547     541
   q16  552     528     538     528
   q17  2036    1839    1806    1806
   q18  8805    8414    8584    8414
   q19  1739    1696    1684    1684
   q20  2319    1993    1983    1983
   q21  5784    5421    5322    5322
   q22  585     487     524     487
   Total cold run time: 64193 ms
   Total hot run time: 60785 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