SERVER-88220 "Enable match pushdown for replaceRoot" commit 21a176e6 caused a -38.4% performance regression in TPCH Denormalized Query 15.
Commenting out the main body (everything but the no-op return statement at the end) of the newly introduced ReplaceRootTransformation::doOptimizeAt() method from SERVER-88220 on the near-latest master level 4e023839 produces a +10.0% performance gain on this query.
This ticket will be used to revert SERVER-88220.
- is duplicated by
-
SERVER-90076 Performance: Revert SERVER-88220 for TPCH Denormalized Query 15
-
- Closed
-
- related to
-
SERVER-90748 Investigate 10% regression in TPCH-denormalized-10/Query15 for replaceRoot match pushdown
-
- Closed
-