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

[5.5.5 BP MB-33006] - Use CountTotal for count aggregate on full index scan

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 6.0.0, 5.5.3, 6.0.1, 5.5.4
    • 5.5.5
    • secondary-index
    • Untriaged
    • No

    Description

      Using CountTotal for count aggregate on full index scan (leading key, no group by) can improve the query performance by a big factor as the count is precomputed.

      Attachments

        Issue Links

          backports to

          Bug - A problem which impairs or prevents the functions of the product. MB-33700 [BP MB-33006] - Use CountTotal for count aggregate on full index scan

          • Major - Major loss of function.
          • Closed
          is a backport of

          Bug - A problem which impairs or prevents the functions of the product. MB-33006 Use CountTotal for count aggregate on full index scan

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            Ascending order - Click to sort in descending order
            deepkaran.salooja Deepkaran Salooja added a comment -

            Wayne Siu, yes we decided to include it in 5.5.5 as multiple customers have requested for it. The code has been isolated so it can be turned off using a config setting in case of any issues.

            deepkaran.salooja Deepkaran Salooja added a comment - Wayne Siu , yes we decided to include it in 5.5.5 as multiple customers have requested for it. The code has been isolated so it can be turned off using a config setting in case of any issues.
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-5.5.5-4518 contains indexing commit ef5119b with commit message:
            MB-34624 optimize count for full index scan

            build-team Couchbase Build Team added a comment - Build couchbase-server-5.5.5-4518 contains indexing commit ef5119b with commit message: MB-34624 optimize count for full index scan
            mihir.kamdar Mihir Kamdar (Inactive) added a comment -

            This is tested on 5.5.5-4521 using the test plan : https://docs.google.com/document/d/1vQYPLEAnzYJlRFQItngbd3nzCtYljzn1sijAgTo6wyM/edit#

            mihir.kamdar Mihir Kamdar (Inactive) added a comment - This is tested on 5.5.5-4521 using the test plan : https://docs.google.com/document/d/1vQYPLEAnzYJlRFQItngbd3nzCtYljzn1sijAgTo6wyM/edit#

            People

              deepkaran.salooja Deepkaran Salooja
              jeelan.poola Jeelan Poola
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty