Slot-Based Engine too aggressively uses disk for $group and is slow

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Critical - P2
    • 6.3.0-rc0, 6.0.5
    • Affects Version/s: None
    • Component/s: None
    • Fully Compatible
    • ALL
    • v6.2, v6.0
    • QE 2023-02-06
    • 10
    • None
    • 0
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Please refer to the discussion here: https://www.mongodb.com/community/forums/t/addtoset-slower-hanging-on-large-collections-since-mongodb-6/192395/3

      In short, there appear to be two issues with the SBE:

      1. It too aggressively resorts to disk for $group processing. In my example above, disk isn't used with the classic engine on 6.0, or on 4.0.
      2. When resorting to disk, it is incredibly slow.

      The only solution was to force the use of the classic query engine, which doesn't seem like a desirable approach.

              Assignee:
              David Storch
              Reporter:
              Steve Micallef
              Votes:
              2 Vote for this issue
              Watchers:
              25 Start watching this issue

                Created:
                Updated:
                Resolved: