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

   
   TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Tpch sf100 test result on commit 8f361c50f61a672888e471225db22075ac7df383, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5000    4618    4649    4618
   q2   370     147     159     147
   q3   1455    1271    1165    1165
   q4   1121    938     895     895
   q5   3183    3173    3164    3164
   q6   250     125     124     124
   q7   1033    490     496     490
   q8   2272    2255    2256    2255
   q9   6690    6704    6668    6668
   q10  3190    3275    3268    3268
   q11  337     212     214     212
   q12  353     209     208     208
   q13  4160    3404    3382    3382
   q14  242     212     213     212
   q15  572     515     513     513
   q16  441     380     392     380
   q17  1043    752     539     539
   q18  7081    6813    6927    6813
   q19  1626    1628    1647    1628
   q20  535     301     336     301
   q21  3163    2722    2755    2722
   q22  382     300     309     300
   Total cold run time: 44499 ms
   Total hot run time: 40004 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   4589    4568    4573    4568
   q2   273     166     171     166
   q3   3366    3372    3360    3360
   q4   2221    2203    2210    2203
   q5   5716    5722    5703    5703
   q6   241     119     118     118
   q7   2386    1903    1861    1861
   q8   3613    3627    3618    3618
   q9   9093    9045    9045    9045
   q10  3800    3876    3903    3876
   q11  495     376     391     376
   q12  771     590     592     590
   q13  3906    3217    3195    3195
   q14  285     262     263     262
   q15  563     521     517     517
   q16  499     452     446     446
   q17  1984    1958    1954    1954
   q18  8669    8190    8231    8190
   q19  1764    1758    1757    1757
   q20  2257    1942    1928    1928
   q21  6130    5781    5743    5743
   q22  530     467     449     449
   Total cold run time: 63151 ms
   Total hot run time: 59925 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