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

   
   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 3c8207fd3bac9e3582471f82785a87eada114150, 
data reload: false
   
   run tpch-sf100 query with default conf and session variables
   q1   5518    5084    5067    5067
   q2   409     167     158     158
   q3   1465    1137    1094    1094
   q4   1098    802     859     802
   q5   3122    3121    3147    3121
   q6   228     136     136     136
   q7   981     551     519     519
   q8   2165    2219    2272    2219
   q9   6731    6644    6648    6644
   q10  3185    3084    3120    3084
   q11  343     216     213     213
   q12  378     231     234     231
   q13  4389    3641    3637    3637
   q14  257     213     213     213
   q15  605     550     543     543
   q16  460     433     397     397
   q17  1051    485     487     485
   q18  7120    6795    6733    6733
   q19  1651    1548    1537    1537
   q20  598     335     342     335
   q21  2879    2481    2495    2481
   q22  407     332     338     332
   Total cold run time: 45040 ms
   Total hot run time: 39981 ms
   
   run tpch-sf100 query with default conf and set session variable 
runtime_filter_mode=off
   q1   5141    5106    5101    5101
   q2   348     251     261     251
   q3   3384    3327    3306    3306
   q4   2136    2037    1967    1967
   q5   5972    5931    5938    5931
   q6   229     123     124     123
   q7   2374    1908    1969    1908
   q8   3591    3699    3657    3657
   q9   9069    8942    8946    8942
   q10  3887    3919    3885    3885
   q11  586     484     469     469
   q12  805     677     691     677
   q13  3895    3181    3201    3181
   q14  298     286     270     270
   q15  616     541     558     541
   q16  570     487     530     487
   q17  2020    1802    1826    1802
   q18  8764    8380    8407    8380
   q19  1761    1750    1676    1676
   q20  2304    1999    1980    1980
   q21  5690    5347    5253    5253
   q22  570     466     489     466
   Total cold run time: 64010 ms
   Total hot run time: 60253 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