[SERVER-84403] Collscan benchmarks - implement new Genny benchmarks for complex $in predicates Created: 22/Dec/23  Updated: 23/Jan/24  Resolved: 23/Jan/24

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.3.0-rc0

Type: Task Priority: Major - P3
Reporter: Anton Korshunov Assignee: Henri Nikku
Resolution: Fixed Votes: 0
Labels: M3
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-84401 Collscan benchmarks - complex $in que... Closed
Backwards Compatibility: Fully Compatible
Sprint: QO 2024-02-05
Participants:

 Description   
  • In the new Genny benchmarks for complex predicates include complex mixed expressions where some of the terms are large $in predicates.
  • There should be large $or with same-path equalities that can be reduced to $in.
  • Mixes of $or and $in with duplicates so that the $or equalities are subsumed by the $in-s.
  • Among the DNF/CNF queries with multiple $in-s there should be cases with
  • large $in-s with a lot of duplicates,
  • $in-s that can be optimized away due to other predicates, e.g.
    (a < 100) AND (a IN [200, 250, 300])
  • The idea with both cases above is that in order to truly reduce the query, it is necessary to know the contents of the $in, which will be problematic if the $in is parameterized.


 Comments   
Comment by Githook User [ 23/Jan/24 ]

Author:

{'name': 'Henri Nikku', 'email': 'henri.nikku@mongodb.com', 'username': 'henrinikku'}

Message: SERVER-84403 Add complex $in queries (#1113)
Branch: master
https://github.com/mongodb/genny/commit/cc0448deec3b88ae17ee8375a9cab4a49199000a

Comment by Henri Nikku [ 17/Jan/24 ]

https://github.com/mongodb/genny/pull/1113

Generated at Thu Feb 08 06:54:56 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.