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

Optimize column scan filter pushdown

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Fully Compatible
    • QE 2022-09-19

      Based on what we've found in profiling, there are a few really simple optimizations for per-column filters that we should do.

      Here's a simple query on the bestbuy dataset which exercises the behavior. The filter does not match anything.

      db.products.aggregate([{$match:{'type': 'asdf'}}, {$group:{_id:'$type', count: {$sum:1}}}])
      

      We should change this to not copy values out of the column index in order to apply the filter to them. This means putting an unowned value into the slot used for filtering here.

      These are only ideas for a starting point. We can also split these into separate tickets.

            Assignee:
            mohammad.dashti@mongodb.com Mohammad Dashti (Inactive)
            Reporter:
            ian.boros@mongodb.com Ian Boros
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: