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

Investigate performance regression in DocumentSourceGroup when allowDiskUse is true

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 6.0.0-rc7, 6.1.0-rc0
    • None
    • None
    • Fully Compatible
    • ALL
    • v6.0
    • QE 2022-05-16
    • 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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: