[SERVER-84202] Allow pushdown of all eligible SBE stages when $search is pushed down Created: 14/Dec/23  Updated: 07/Feb/24  Resolved: 21/Dec/23

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: Adi Agrawal Assignee: Adi Agrawal
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Problem/Incident
causes SERVER-86281 $search with access to $$SEARCH_META ... Needs Scheduling
Related
is related to SERVER-86367 Revert changes in SERVER-84202 In Code Review
Backwards Compatibility: Fully Compatible
Sprint: QE 2023-12-25
Participants:

 Description   

SERVER-83685 made "trySbeRestricted" the default knob on master. We allow $search to be pushed down into sbe when "trySbeRestricted" is on, however, we lose out on the benefits of some optimizations when other stages are restricted in SBE with search. Since, search does not use multi planning, it is safe from any slowness from the SBE multiplanner. We should push down all eligible stages to SBE when $search is pushed down to benefit from faster execution and certain optimizations like search + limit. 



 Comments   
Comment by Githook User [ 21/Dec/23 ]

Author:

{'name': 'Adityavardhan Agrawal', 'email': 'adi.agrawal@mongodb.com', 'username': 'Adityav369'}

Message: SERVER-84202 Allow full sbe pushdown when running a search query

GitOrigin-RevId: 6b2bc6619ec3be0efd3fb4a1a07b993db43a23cb
Branch: master
https://github.com/mongodb/mongo/commit/ba4dcbe6029125e794174745bc2ed91ff4de9424

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