Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-66215

Investigate performance regression in DocumentSourceGroup when allowDiskUse is true

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.0.0-rc7, 6.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • ALL
    • v6.0
    • QE 2022-05-16
    • 146

      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.

            Assignee:
            romans.kasperovics@mongodb.com Romans Kasperovics
            Reporter:
            eric.cox@mongodb.com Eric Cox (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: