You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "doris-robot (via GitHub)" <gi...@apache.org> on 2024/06/21 14:26:34 UTC
Re: [PR] [Improve] Set default value for enable_unique_key_merge_on_write [doris]
doris-robot commented on PR #36624:
URL: https://github.com/apache/doris/pull/36624#issuecomment-2180550157
<details>
<summary>TPC-H: <b>Total hot run time: 40061 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 713e6d6d967da5de8ec3d72b55946ea4dedd8202, data reload: false
------ Round 1 ----------------------------------
q1 17604 4425 4273 4273
q2 2025 190 203 190
q3 10426 1148 1112 1112
q4 10183 802 877 802
q5 7551 2657 2589 2589
q6 235 140 137 137
q7 959 612 610 610
q8 9223 2090 2057 2057
q9 9176 6549 6527 6527
q10 9046 3774 3782 3774
q11 454 250 244 244
q12 509 241 238 238
q13 18864 2981 2992 2981
q14 263 223 227 223
q15 522 467 468 467
q16 516 389 384 384
q17 976 728 702 702
q18 8046 7446 7348 7348
q19 1662 1516 1491 1491
q20 657 328 330 328
q21 4945 3245 3904 3245
q22 401 339 340 339
Total cold run time: 114243 ms
Total hot run time: 40061 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4330 4316 4205 4205
q2 405 269 264 264
q3 3009 2698 2770 2698
q4 1888 1616 1638 1616
q5 5271 5295 5258 5258
q6 221 128 131 128
q7 2166 1742 1760 1742
q8 3198 3347 3342 3342
q9 8370 8356 8327 8327
q10 3945 3683 3699 3683
q11 587 485 496 485
q12 776 618 618 618
q13 17410 2976 2990 2976
q14 304 256 283 256
q15 514 474 463 463
q16 472 411 415 411
q17 1785 1534 1479 1479
q18 7583 7579 7450 7450
q19 1674 1583 1540 1540
q20 1991 1781 1772 1772
q21 4831 4764 4706 4706
q22 622 551 541 541
Total cold run time: 71352 ms
Total hot run time: 53960 ms
```
</details>
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org