[SERVER-74451] Implement limit pushdown to mongot cursor Created: 28/Feb/23  Updated: 29/Oct/23  Resolved: 01/May/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.1.0-rc0, 6.0.7, 7.0.0-rc3, 5.0.20

Type: Task Priority: Major - P3
Reporter: Nicholas Zolnierz Assignee: Militsa Sotirova
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
is depended on by SERVER-75666 Add oversubscription feature Closed
is depended on by SERVER-76404 Call the no-prefetch TaskExecutorCurs... Closed
Duplicate
is duplicated by SERVER-69873 Send skip/limit/batchSize to mongot Closed
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Backport Requested:
v7.0, v6.0, v5.0, v4.4
Sprint: QO 2023-05-15
Participants:

 Description   

Rough sketch of tasks for this ticket:

  1. During parsing/desugaring, extract an appropriate limit (if possible) based on the pipeline suffix of a $search pipeline
  2. Build an $_internalMongotRemote stage with the limit
  3. Construct a mongot cursor with the extracted limit as a batch size (exact syntax will be determined by search team's spec)

Note that this ticket does not need to handle the case where a document is filtered out by $idLookup, and thus no getMores are needed on the mongot cursor.



 Comments   
Comment by Githook User [ 06/Jul/23 ]

Author:

{'name': 'Militsa Sotirova', 'email': 'militsa.sotirova@mongodb.com', 'username': 'militsasotirova'}

Message: SERVER-74451 Implement limit pushdown to mongot cursor
Branch: v5.0
https://github.com/mongodb/mongo/commit/4ab604c7b94db26efdfa5768adc3288d7cf33803

Comment by Githook User [ 31/May/23 ]

Author:

{'name': 'Militsa Sotirova', 'email': 'militsa.sotirova@mongodb.com', 'username': 'militsasotirova'}

Message: SERVER-74451 Implement limit pushdown to mongot cursor
Branch: v6.0
https://github.com/mongodb/mongo/commit/f4ce4940de155ff5cde40fc467d813f0080a0afd

Comment by Githook User [ 30/May/23 ]

Author:

{'name': 'Militsa Sotirova', 'email': 'militsa.sotirova@mongodb.com', 'username': 'militsasotirova'}

Message: SERVER-74451 Implement limit pushdown to mongot cursor
Branch: v7.0
https://github.com/mongodb/mongo/commit/a61de9be8e36d33847b88afee5e6cc6be78ed99a

Comment by Githook User [ 01/May/23 ]

Author:

{'name': 'Militsa Sotirova', 'email': 'militsa.sotirova@mongodb.com', 'username': 'militsasotirova'}

Message: SERVER-74451 Implement limit pushdown to mongot cursor
Branch: master
https://github.com/mongodb/mongo/commit/2e4e0966a2c9c6b2e77f23513388d1def7072f81

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