[SERVER-64432] supporting caching SBE Plan for $lookup Created: 11/Mar/22  Updated: 29/Oct/23  Resolved: 22/Jun/22

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

Type: New Feature Priority: Major - P3
Reporter: Rushan Chen Assignee: Rui Liu
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-64237 Cleanup IDHack code when all SBE quer... Closed
is depended on by SERVER-59708 Make plan_explainer plan cache functi... Closed
Backwards Compatibility: Fully Compatible
Sprint: QE 2022-05-02, QE 2022-05-16, QE 2022-05-30, QE 2022-06-13, QE 2022-06-27
Participants:

 Description   

$lookup SBE plan should work with the new SBE Plan Cache, 

(1) Verify that $lookup SBE plans are cached, matched and evicted correctly.

(2) For invalidation, $lookup SBE plan should support the invalidation protocol from the new SBE Plan Cache. Changes in both the local and the foriegn collection (including indexes) that affect the SBE Plan should cause corresponding plans to be invalidated.

(3) For the post match valdiation "trial", the definition of "work" needs to be adjusted based on SBE Plans.  



 Comments   
Comment by Githook User [ 23/Jun/22 ]

Author:

{'name': 'Rui Liu', 'email': 'rui.liu@mongodb.com', 'username': 'lriuui0x0'}

Message: SERVER-64432 Integrate SBE plan cache for $lookup
Branch: davish/SERVER-63099
https://github.com/mongodb/mongo/commit/2c2d85e73d0620d779544ce67218db171c154e8b

Comment by Githook User [ 22/Jun/22 ]

Author:

{'name': 'Rui Liu', 'email': 'rui.liu@mongodb.com', 'username': 'lriuui0x0'}

Message: SERVER-64432 Integrate SBE plan cache for $lookup
Branch: master
https://github.com/mongodb/mongo/commit/2c2d85e73d0620d779544ce67218db171c154e8b

Comment by Rushan Chen [ 15/Mar/22 ]

Will keep this for after 6.0.

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