[SERVER-66215] Investigate performance regression in DocumentSourceGroup when allowDiskUse is true Created: 04/May/22  Updated: 29/Oct/23  Resolved: 20/May/22

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

Type: Bug Priority: Major - P3
Reporter: Eric Cox (Inactive) Assignee: Romans Kasperovics
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Problem/Incident
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v6.0
Sprint: QE 2022-05-16
Participants:
Linked BF Score: 146

 Description   

In investigating BF-25112 a 20% regression was discovered after SERVER-63208 landed on master. An initial investigation ruled out $lookup in sbe from being the cause due to presence of an inner pipeline syntax. 

The investigator should profile DocumentSourceGroup with the following query 

db.foo.aggregate([{"$group": {"_id" : {"$sum" : ["$int", 1 ]}}])

With allowDiskUse defaulted to true and allowDiskUse=false.



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

Author:

{'name': 'Romans Kasperovics', 'email': 'romans.kasperovics@mongodb.com', 'username': 'romanskas'}

Message: SERVER-66215 Create Sorter::File instances only when actually needed

(cherry picked from commit dd2874d1fc652344154233fa1dbb5fd313a99463)
Branch: v6.0
https://github.com/mongodb/mongo/commit/aaa27a3f0fd75994584b7e5e4c08fcd86bb8af38

Comment by Githook User [ 20/May/22 ]

Author:

{'name': 'Romans Kasperovics', 'email': 'romans.kasperovics@mongodb.com', 'username': 'romanskas'}

Message: SERVER-66215 Create Sorter::File instances only when actually needed
Branch: master
https://github.com/mongodb/mongo/commit/dd2874d1fc652344154233fa1dbb5fd313a99463

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