Details
-
Task
-
Resolution: Done
-
Major - P3
-
None
-
None
-
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
Description
| 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.
Attachments
Issue Links
- 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
-