andygrove commented on PR #2600:
URL:
https://github.com/apache/datafusion-comet/pull/2600#issuecomment-3558899296
Here are microbenchmark results:
### Legacy mode
```
OpenJDK 64-Bit Server VM 17.0.16+8-Ubuntu-0ubuntu122.04.1 on Linux
6.8.0-87-generic
AMD Ryzen 9 7950X3D 16-Core Processor
TPCDS Micro Benchmarks: Best Time(ms) Avg Time(ms)
Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
agg_sum_integers_no_grouping 1720 1812
129 167.4 6.0 1.0X
agg_sum_integers_no_grouping: Comet 1171 1179
11 246.0 4.1 1.5X
Running benchmark: TPCDS Micro Benchmarks
Running case: agg_sum_integers_with_grouping
Stopped after 2 iterations, 5105 ms
Running case: agg_sum_integers_with_grouping: Comet
Stopped after 2 iterations, 2803 ms
OpenJDK 64-Bit Server VM 17.0.16+8-Ubuntu-0ubuntu122.04.1 on Linux
6.8.0-87-generic
AMD Ryzen 9 7950X3D 16-Core Processor
TPCDS Micro Benchmarks: Best Time(ms) Avg Time(ms)
Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
agg_sum_integers_with_grouping 2529 2553
34 113.9 8.8 1.0X
agg_sum_integers_with_grouping: Comet 1396 1402
8 206.3 4.8 1.8X
```
### ANSI mode
```
OpenJDK 64-Bit Server VM 17.0.16+8-Ubuntu-0ubuntu122.04.1 on Linux
6.8.0-87-generic
AMD Ryzen 9 7950X3D 16-Core Processor
TPCDS Micro Benchmarks: Best Time(ms) Avg Time(ms)
Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
agg_sum_integers_no_grouping 1751 1802
72 164.5 6.1 1.0X
agg_sum_integers_no_grouping: Comet 1358 1360
3 212.1 4.7 1.3X
Running benchmark: TPCDS Micro Benchmarks
Running case: agg_sum_integers_with_grouping
Stopped after 2 iterations, 5563 ms
Running case: agg_sum_integers_with_grouping: Comet
Stopped after 2 iterations, 3668 ms
OpenJDK 64-Bit Server VM 17.0.16+8-Ubuntu-0ubuntu122.04.1 on Linux
6.8.0-87-generic
AMD Ryzen 9 7950X3D 16-Core Processor
TPCDS Micro Benchmarks: Best Time(ms) Avg Time(ms)
Stdev(ms) Rate(M/s) Per Row(ns) Relative
------------------------------------------------------------------------------------------------------------------------
agg_sum_integers_with_grouping 2772 2782
14 103.9 9.6 1.0X
agg_sum_integers_with_grouping: Comet 1834 1834
1 157.1 6.4 1.5X
```
--
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]
