-
Type:
Bug
-
Resolution: Done
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
-
Fully Compatible
-
ALL
-
(copied to CRM)
-
None
-
None
-
None
-
None
-
None
-
None
-
None
HELP-79916 highlights a case where a query with a large number of predicates to simplify caused out of memory issues for a customer that upgraded to 8.0.
Despite the customer’s query containing fewer unique predicates than the default value of 64 for the parameter internalQueryMaximumNumberOfUniquePredicatesToSimplify, the issue still occurred.
We should investigate whether any bugs in the boolean simplifier code could have contributed to this high memory consumption. Additionally, we should investigate why the default value of 64 was insufficient in preventing the problem and consider lowering the default value.
- is related to
-
SERVER-114126 Reduce memory usage and add new guardrails to the boolean simplifier
-
- Closed
-