findepi commented on PR #17563:
URL: https://github.com/apache/datafusion/pull/17563#issuecomment-3291864400
```
cargo bench --bench sql_planner -- physical_window_function_partition
```
### Before
```
Found 6 outliers among 100 measurements (6.00%)
3 (3.00%) high mild
3 (3.00%) high severe
physical_window_function_partition_by_7_on_values
time: [22.985 ms 23.007 ms 23.033 ms]
Found 5 outliers among 100 measurements (5.00%)
3 (3.00%) high mild
2 (2.00%) high severe
Benchmarking physical_window_function_partition_by_8_on_values: Warming up
for 3.0000 s
Warning: Unable to complete 100 samples in 5.0s. You may wish to increase
target time to 9.4s, or reduce sample count to 50.
physical_window_function_partition_by_8_on_values
time: [94.241 ms 94.382 ms 94.541 ms]
Found 5 outliers among 100 measurements (5.00%)
4 (4.00%) high mild
1 (1.00%) high severe
Benchmarking physical_window_function_partition_by_12_on_values: Warming up
for 3.0000 s
Warning: Unable to complete 100 samples in 5.0s. You may wish to increase
target time to 2839.3s, or reduce sample count to 10.
physical_window_function_partition_by_12_on_values
time: [28.261 s 28.270 s 28.279 s]
Found 1 outliers among 100 measurements (1.00%)
```
### After
```
physical_window_function_partition_by_4_on_values
time: [173.42 µs 173.49 µs 173.58 µs]
change: [-64.728% -64.636% -64.541%] (p = 0.00 <
0.05)
Performance has improved.
Found 7 outliers among 100 measurements (7.00%)
2 (2.00%) high mild
5 (5.00%) high severe
physical_window_function_partition_by_7_on_values
time: [224.85 µs 225.07 µs 225.32 µs]
change: [-99.020% -99.019% -99.016%] (p = 0.00 <
0.05)
Performance has improved.
Found 1 outliers among 100 measurements (1.00%)
1 (1.00%) high severe
physical_window_function_partition_by_8_on_values
time: [245.12 µs 245.79 µs 246.64 µs]
change: [-99.741% -99.740% -99.739%] (p = 0.00 <
0.05)
Performance has improved.
Found 11 outliers among 100 measurements (11.00%)
3 (3.00%) high mild
8 (8.00%) high severe
physical_window_function_partition_by_12_on_values
time: [313.47 µs 315.07 µs 317.13 µs]
change: [-99.999% -99.999% -99.999%] (p = 0.00 <
0.05)
Performance has improved.
Found 34 outliers among 100 measurements (34.00%)
6 (6.00%) low severe
17 (17.00%) low mild
4 (4.00%) high mild
7 (7.00%) high severe
```
A `-99.999%` improvement on a query involving just 12 columns. Not bad.
--
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: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
