Tan-JiaLiang commented on PR #6209:
URL: https://github.com/apache/paimon/pull/6209#issuecomment-3259001186
```text
Running benchmark: topn
Running case: without-index-300-1
Stopped after 1 iterations, 466 ms
Running case: with-index-300-1
Stopped after 1 iterations, 18 ms
OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6.1
Apple M4 Pro
topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATORTEST_topn_without-index-300-1
467 / 467 2142.2 466.8
1.0X
OPERATORTEST_topn_with-index-300-1
18 / 18 55111.9 18.1
25.7X
Running benchmark: multiple-topn
Running case: without-index-300-1
Stopped after 1 iterations, 477 ms
Running case: with-index-300-1
Stopped after 1 iterations, 489 ms
OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6.1
Apple M4 Pro
multiple-topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATORTEST_multiple-topn_without-index-300-1
478 / 478 2093.3 477.7
1.0X
OPERATORTEST_multiple-topn_with-index-300-1
490 / 490 2042.3 489.6
1.0X
Running benchmark: topn
Running case: without-index-3000-1
Stopped after 1 iterations, 467 ms
Running case: with-index-3000-1
Stopped after 1 iterations, 10 ms
OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6.1
Apple M4 Pro
topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATORTEST_topn_without-index-3000-1
468 / 468 2138.4 467.6
1.0X
OPERATORTEST_topn_with-index-3000-1
10 / 10 96270.7 10.4
45.0X
Running benchmark: multiple-topn
Running case: without-index-3000-1
Stopped after 1 iterations, 464 ms
Running case: with-index-3000-1
Stopped after 1 iterations, 475 ms
OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6.1
Apple M4 Pro
multiple-topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATORTEST_multiple-topn_without-index-3000-1
464 / 464 2153.9 464.3
1.0X
OPERATORTEST_multiple-topn_with-index-3000-1
476 / 476 2101.0 476.0
1.0X
Running benchmark: topn
Running case: without-index-30000-1
Stopped after 1 iterations, 478 ms
Running case: with-index-30000-1
Stopped after 1 iterations, 17 ms
OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6.1
Apple M4 Pro
topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATORTEST_topn_without-index-30000-1
478 / 478 2091.6 478.1
1.0X
OPERATORTEST_topn_with-index-30000-1
18 / 18 56727.8 17.6
27.1X
Running benchmark: multiple-topn
Running case: without-index-30000-1
Stopped after 1 iterations, 461 ms
Running case: with-index-30000-1
Stopped after 1 iterations, 235 ms
OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6.1
Apple M4 Pro
multiple-topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATORTEST_multiple-topn_without-index-30000-1
462 / 462 2165.2 461.9
1.0X
OPERATORTEST_multiple-topn_with-index-30000-1
236 / 236 4243.1 235.7
2.0X
Running benchmark: topn
Running case: without-index-300000-1
Stopped after 1 iterations, 495 ms
Running case: with-index-300000-1
Stopped after 1 iterations, 18 ms
OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6.1
Apple M4 Pro
topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATORTEST_topn_without-index-300000-1
496 / 496 2018.1 495.5
1.0X
OPERATORTEST_topn_with-index-300000-1
19 / 19 53011.7 18.9
26.3X
Running benchmark: multiple-topn
Running case: without-index-300000-1
Stopped after 1 iterations, 494 ms
Running case: with-index-300000-1
Stopped after 1 iterations, 52 ms
OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6.1
Apple M4 Pro
multiple-topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATORTEST_multiple-topn_without-index-300000-1
495 / 495 2021.9 494.6
1.0X
OPERATORTEST_multiple-topn_with-index-300000-1
53 / 53 18895.5 52.9
9.3X
Running benchmark: topn
Running case: without-index-3000000-1
Stopped after 1 iterations, 532 ms
Running case: with-index-3000000-1
Stopped after 1 iterations, 15 ms
OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6.1
Apple M4 Pro
topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATORTEST_topn_without-index-3000000-1
533 / 533 1877.8 532.5
1.0X
OPERATORTEST_topn_with-index-3000000-1
16 / 16 62928.7 15.9
33.5X
Running benchmark: multiple-topn
Running case: without-index-3000000-1
Stopped after 1 iterations, 525 ms
Running case: with-index-3000000-1
Stopped after 1 iterations, 15 ms
OpenJDK 64-Bit Server VM 1.8.0_442-b06 on Mac OS X 15.6.1
Apple M4 Pro
multiple-topn:
Best/Avg Time(ms) Row Rate(K/s) Per Row(ns)
Relative
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATORTEST_multiple-topn_without-index-3000000-1
526 / 526 1902.2 525.7
1.0X
OPERATORTEST_multiple-topn_with-index-3000000-1
16 / 16 62878.4 15.9
33.1X
```
--
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]