-
Type: Task
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Execution
-
Fully Compatible
-
QE 2023-02-06, QE 2023-02-20, QE 2023-03-06, QE 2023-03-20, QE 2023-04-03
-
2
variadic_aggregate_expressions | VariadicExpressionSetEqualsHundred.VariadicAggExpressionSetEqualsHundred | -107.6554137 |
variadic_aggregate_expressions | VariadicExpressionAddHundred.VariadicAggExpressionAddHundred | -98.81069057 |
variadic_aggregate_expressions | VariadicExpressionMultiplyHundred.VariadicAggExpressionMultiplyHundred | -78.62192546 |
variadic_aggregate_expressions | VariadicExpressionAddFifty.VariadicAggExpressionAddFifty | -55.00343602 |
variadic_aggregate_expressions | VariadicExpressionSetEqualsFifty.VariadicAggExpressionSetEqualsFifty | -48.46890079 |
variadic_aggregate_expressions | VariadicExpressionMultiplyFifty.VariadicAggExpressionMultiplyFifty | -39.4838081 |
(note that this is likely related to the RunMultiply regressions: SERVER-70806)
We should also consider whether we expect these to perform well at all; these expressions use an arguably unrealistic number of arguments, but serve to demonstrate that, at the time of filing this ticket, aggregate expressions scale poorly in the number of arguments.
- is related to
-
SERVER-70806 Investigate 'RunMultiply' regressions
- Closed
- related to
-
SERVER-75332 Fix variadic aggregate expression regressions
- Backlog
-
SERVER-70806 Investigate 'RunMultiply' regressions
- Closed