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

Assess $group queries perf at the bucket level

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 6.1.0-rc0
    • None
    • None
    • None
    • Fully Compatible

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: