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

Implement planning from cache for queries with pushed down $group

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: None
    • Labels:
      None
    • Sprint:
      QE 2021-10-04, QE 2021-10-18, QE 2021-11-01

      Description

      NOTE There is ongoing work to create a new plan cache just for SBE plans. That work may affect what we decide to do here. The assignee of this ticket should ensure that the plan for the SBE plan caching project does not conflict with what we do under this ticket.

      The plan cache will only store winning solutions for the "lower" part of a QSN tree (the result of multi planning). To build an execution tree from a cache entry, we will first have to graft the 'postMultiPlan' QSN tree onto the QSN tree of the winning plan.

      This work will also involve modifying replanning code to only perform re-planning on portions of the tree that are multi-planned. There may also be some work to change the re-planning code to only use the number of reads done by the 'left' side of the query.

        Attachments

          Activity

            People

            Assignee:
            irina.yatsenko Irina Yatsenko
            Reporter:
            ian.boros Ian Boros
            Participants:
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: