Need to run performance tests on $percentile in window functions with large windows.
Some considerations for improvements could be
- Computing all requested percentiles at once.
- Iterating in reverse for p > 0.5.
- Change how we store _values (potentially use absl::btree_multiset and not std::multiset). This could decrease memory usage.
Run $percentile on window functions on queries and measure the latency.
- depends on
-
SERVER-74559 Support $percentile and $median in window functions
-
- Closed
-