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

Allow create view indexes with defer build?

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Won't Fix
    • Major
    • feature-backlog
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • None
    • 400-2093

    Description

      To have equivalent usage or almost equivalent - Can we have "defer build" view indexes.

      Currently we do not allow Defer for View indexes - But this might work well for cases like say tpcc, where I am trying to create 20 indexes on 10 buckets and would want to defer building indexes to not stress the system?

      cbq> create primary index px_default on default using view WITH

      {'defer_build':true}

      ;
      {
      "requestID": "9f3d0f88-f7b2-47c4-a5ba-0b7e5459875a",
      "signature": null,
      "results": [
      ],
      "errors": [

      { "code": 13004, "msg": "Views not allowed for WITH keyword " }

      ],
      "status": "errors",
      "metrics":

      { "elapsedTime": "107.168768ms", "executionTime": "105.384887ms", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      Attachments

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

        Activity

          People

            jeelan.poola Jeelan Poola
            ketaki Ketaki Gangal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty