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

   
   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 397418ed4ce8e5357f93c2e483fffe8d72d6342b, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5497    5182    5110    5110
   q2   400     174     160     160
   q3   1468    1160    1131    1131
   q4   1092    827     768     768
   q5   3158    3154    3173    3154
   q6   225     144     142     142
   q7   990     546     529     529
   q8   2185    2300    2227    2227
   q9   6692    6692    6678    6678
   q10  3213    3130    3079    3079
   q11  336     228     212     212
   q12  381     235     238     235
   q13  4417    3620    3600    3600
   q14  248     224     214     214
   q15  578     539     533     533
   q16  448     405     396     396
   q17  1056    498     557     498
   q18  7164    6808    6995    6808
   q19  1660    1577    1500    1500
   q20  560     373     356     356
   q21  2938    2449    2514    2449
   q22  402     341     309     309
   Total cold run time: 45108 ms
   Total hot run time: 40088 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5112    5099    5025    5025
   q2   346     237     227     227
   q3   3390    3377    3315    3315
   q4   2150    2091    2085    2085
   q5   5957    5962    5936    5936
   q6   225     128     133     128
   q7   2403    1967    1960    1960
   q8   3556    3665    3655    3655
   q9   9091    9021    8988    8988
   q10  3905    3882    3934    3882
   q11  573     483     467     467
   q12  803     631     651     631
   q13  3886    3207    3150    3150
   q14  312     271     273     271
   q15  590     534     539     534
   q16  562     528     513     513
   q17  2050    1819    1814    1814
   q18  8714    8396    8350    8350
   q19  1744    1707    1724    1707
   q20  2268    1973    1959    1959
   q21  5815    5359    5310    5310
   q22  558     506     480     480
   Total cold run time: 64010 ms
   Total hot run time: 60387 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