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

Assess $group queries perf at the bucket level

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible

      The idea is to measure performance of the following query:

      {$group: {_id:"ticker", m: {$min: {price}}}}
      

      in two scenarios:

      • against a TS collection. All the data will be unpacked before grouping.
      • against the corresponding bucket collection. Buckets will not be unpacked at all and min will be calculated based on mins stored in buckets. This requires rewriting this query to an equivalent version working with buckets.

      The point of the experiment is to give us an idea of the performance boost, as we can extrapolate what the boost would be if a portion of buckets needs to be unpacked, e.g. due to a filter on time. We expect orders of magnitude.

      At the moment we believe that queries that conceptually do not need to unpack a portion of buckets are common. We can confirm that using telemetry in the future.

            Assignee:
            rui.liu@mongodb.com Rui Liu
            Reporter:
            pawel.terlecki@mongodb.com Pawel Terlecki (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: