Company
Date Published
Author
Kirk Kirkconnell, Senior Solutions Engineer, Couchbase
Word count
422
Language
English
Hacker News points
None

Summary

Couchbase 4.x offers a feature that enhances the creation of Global Secondary Indexes by allowing users to queue index creation statements and then execute them in parallel for improved efficiency and performance. This is particularly useful when creating multiple indexes with high availability, as users can defer the creation of indexes and later instruct the cluster to build them simultaneously using the BUILD INDEX command. This approach leverages the same Database Change Protocol (DCP) stream from Data Service nodes, optimizing network I/O utilization and significantly reducing the time required compared to a serial creation process. The parallel execution means that each Index Service node only needs a single DCP stream of the bucket’s data, leading to faster completion, especially beneficial when scripting multiple index creations in batches. Users are encouraged to explore this feature and consult the documentation for further guidance on its implementation.