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

Investigate parallel execution for $lookup with a foreign sharded view

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • Query Optimization

    Description

      After SERVER-59501, mongos allows a top-level $lookup stage to be executed in parallel across shards when it thinks the foreign namespace is sharded. However, it seems mongos does not have the necessary information to determine whether or not a foreign view is sharded. In that case, the namespace is treated like an unsharded collection, and the $lookup isn't parallelized.

      This ticket is to investigate if it is possible for mongos to determine that the namespace is a sharded view and to parallelize the top-level $lookup execution in that case. 

      Attachments

        Activity

          People

            backlog-query-optimization Backlog - Query Optimization
            hana.pearlman@mongodb.com Hana Pearlman
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: