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

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            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 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#

            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