JasonLi-cn commented on PR #11758:
URL: https://github.com/apache/datafusion/pull/11758#issuecomment-2270300639
## Benchmark(main VS this branch)
```
cargo bench --bench aggregate_query_sql
```
```shell
Gnuplot not found, using plotters backend
aggregate_query_no_group_by 15 12
time: [2.1563 ms 2.1686 ms 2.1824 ms]
change: [-0.1065% +1.0107% +2.0667%] (p = 0.07 >
0.05)
No change in performance detected.
Found 9 outliers among 100 measurements (9.00%)
7 (7.00%) high mild
2 (2.00%) high severe
aggregate_query_no_group_by_min_max_f64
time: [2.0533 ms 2.0655 ms 2.0782 ms]
change: [-0.2686% +0.5618% +1.4604%] (p = 0.21 >
0.05)
No change in performance detected.
Found 3 outliers among 100 measurements (3.00%)
3 (3.00%) high mild
aggregate_query_no_group_by_count_distinct_wide
time: [2.8570 ms 2.8720 ms 2.8884 ms]
change: [-1.1717% -0.2697% +0.6437%] (p = 0.57 >
0.05)
No change in performance detected.
Found 11 outliers among 100 measurements (11.00%)
6 (6.00%) high mild
5 (5.00%) high severe
aggregate_query_no_group_by_count_distinct_narrow
time: [2.6355 ms 2.6427 ms 2.6502 ms]
change: [-0.3158% +0.1024% +0.5289%] (p = 0.64 >
0.05)
No change in performance detected.
Found 4 outliers among 100 measurements (4.00%)
1 (1.00%) low mild
3 (3.00%) high mild
aggregate_query_group_by
time: [3.1874 ms 3.2218 ms 3.2633 ms]
change: [+0.8142% +2.0424% +3.3431%] (p = 0.00 <
0.05)
Change within noise threshold.
Found 10 outliers among 100 measurements (10.00%)
1 (1.00%) low mild
2 (2.00%) high mild
7 (7.00%) high severe
aggregate_query_group_by_with_filter
time: [3.2268 ms 3.2375 ms 3.2499 ms]
change: [-0.8765% -0.3444% +0.1488%] (p = 0.19 >
0.05)
No change in performance detected.
Found 5 outliers among 100 measurements (5.00%)
3 (3.00%) high mild
2 (2.00%) high severe
aggregate_query_group_by_u64 15 12
time: [2.9613 ms 2.9724 ms 2.9841 ms]
change: [-1.6244% -1.0331% -0.4294%] (p = 0.00 <
0.05)
Change within noise threshold.
Found 2 outliers among 100 measurements (2.00%)
2 (2.00%) high mild
aggregate_query_group_by_with_filter_u64 15 12
time: [3.1977 ms 3.2092 ms 3.2215 ms]
change: [-0.5511% -0.0732% +0.4691%] (p = 0.77 >
0.05)
No change in performance detected.
Found 10 outliers among 100 measurements (10.00%)
1 (1.00%) low mild
5 (5.00%) high mild
4 (4.00%) high severe
aggregate_query_group_by_u64_multiple_keys
time: [6.4762 ms 6.5397 ms 6.6054 ms]
change: [+0.9528% +2.4183% +3.9063%] (p = 0.00 <
0.05)
Change within noise threshold.
Found 1 outliers among 100 measurements (1.00%)
1 (1.00%) high mild
aggregate_query_approx_percentile_cont_on_u64
time: [6.2755 ms 6.3326 ms 6.3915 ms]
change: [-4.7095% -2.6423% -0.8346%] (p = 0.01 <
0.05)
Change within noise threshold.
Found 1 outliers among 100 measurements (1.00%)
1 (1.00%) high mild
aggregate_query_approx_percentile_cont_on_f32
time: [5.4463 ms 5.4856 ms 5.5275 ms]
change: [-1.1171% -0.1131% +0.9433%] (p = 0.83 >
0.05)
No change in performance detected.
Found 2 outliers among 100 measurements (2.00%)
2 (2.00%) high mild
aggregate_query_distinct_median
time: [4.1459 ms 4.1710 ms 4.1962 ms]
change: [-1.0176% -0.1285% +0.7244%] (p = 0.78 >
0.05)
No change in performance detected.
```
--
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]
