Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-28036

3x drop in throughput of aggregation queries

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0
    • 5.5.0
    • secondary-index
    • CentOS 7.4
      E5-2680 v3 (48 vCPU)
    • Untriaged
    • Yes

    Description

      Setup:

      • 4 data nodes, 1 query node, 1 index node
      • 1 bucket
      • 20M documents
      • MOI

      Index:

      CREATE INDEX idx ON `bucket-1`(capped_small, year, coins);

      Query (1K matches)

      SELECT year, SUM(coins) AS coins FROM `bucket-1` WHERE capped_small > $1 AND capped_small < $2 GROUP BY year;

      Attachments

        1. CI6.png
          CI6.png
          125 kB
        2. cpu.svg
          226 kB

        Issue Links

          is caused by

          Task - A task that needs to be done. MB-27049 GSI: Optimize by avoiding multiple decodes in scan_pipeline

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              deepkaran.salooja Deepkaran Salooja
              pavelpaulau Pavel Paulau (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty