[SERVER-79367] Optimize projections in Bonsai Created: 26/Jul/23 Updated: 28/Nov/23 Resolved: 20/Nov/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.3.0-rc0 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Alya Berciu | Assignee: | Alya Berciu |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | M2, auto-reverted | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||||||||||||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||||||||||||||||||||||||||||||||||
| Sprint: | QO 2023-09-04, QO 2023-09-18, QO 2023-10-02, QO 2023-10-16, QO 2023-10-30, QO 2023-11-13, QO 2023-11-27 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||||||||||||||||||||||||||
| Linked BF Score: | 35 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Description |
|
Plans which include projections in Bonsai can produce additional SBE code that may be negatively impacting the performance of projection microbenchmarks. For example, the SBE plan generated by the stage builders for the simple query db.a.find({}, {a: 1, b: 1, c: 1}) is:
While the SBE plan generated by Bonsai is much more complicated:
|
| Comments |
| Comment by Githook User [ 20/Nov/23 ] |
|
Author: {'name': 'Alya Berciu', 'email': 'alya.berciu@mongodb.com', 'username': 'alyacb'}Message: This reverts commit 43c42019fee86ebf3d85a2e7f3873686f6e546d2. |
| Comment by Githook User [ 18/Nov/23 ] |
|
Author: {'name': 'auto-revert-processor', 'email': 'dev-prod-dag@mongodb.com', 'username': ''}Message: Revert " This reverts commit fcb7d5e9d4d256d1c33f69b406bf75731a83a192. |
| Comment by Githook User [ 17/Nov/23 ] |
|
Author: {'name': 'Alya Carina Berciu', 'email': 'alya.berciu@mongodb.com', 'username': 'alyacb'}Message: |