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/07/11 16:16:10 UTC
Re: [PR] [Optimize](Row store) allow to set row_store_page_size for tables, change default value to 16KB [doris]
doris-robot commented on PR #37145:
URL: https://github.com/apache/doris/pull/37145#issuecomment-2223348176
<details>
<summary>TPC-H: <b>Total hot run time: 40191 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 c32b788d667e328a7fc3ca575c8c3ce3aa8f41a0, data reload: false
------ Round 1 ----------------------------------
q1 17783 4748 4305 4305
q2 2035 194 191 191
q3 10535 1219 1153 1153
q4 10221 838 794 794
q5 7549 2758 2701 2701
q6 221 138 139 138
q7 963 605 606 605
q8 9169 2085 2091 2085
q9 8665 6567 6557 6557
q10 8872 3776 3771 3771
q11 483 240 240 240
q12 395 231 228 228
q13 18853 2996 3009 2996
q14 279 239 238 238
q15 549 495 490 490
q16 530 380 376 376
q17 1000 640 698 640
q18 8213 7532 7247 7247
q19 6478 1605 1518 1518
q20 664 328 333 328
q21 4915 3312 3252 3252
q22 387 347 338 338
Total cold run time: 118759 ms
Total hot run time: 40191 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4522 4306 4283 4283
q2 389 281 277 277
q3 3145 2985 2936 2936
q4 1962 1755 1731 1731
q5 5579 5567 5463 5463
q6 225 141 135 135
q7 2324 1902 1841 1841
q8 3298 3450 3404 3404
q9 8811 8959 8856 8856
q10 4145 3795 3819 3795
q11 584 499 502 499
q12 807 655 614 614
q13 15854 3167 3167 3167
q14 335 299 301 299
q15 552 488 481 481
q16 504 453 439 439
q17 1884 1534 1511 1511
q18 8276 8091 7904 7904
q19 1777 1656 1565 1565
q20 2187 1873 1856 1856
q21 9787 4777 4786 4777
q22 662 551 578 551
Total cold run time: 77609 ms
Total hot run time: 56384 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