Huge index size

Hello,
I have this huge indexes.
Instead of having only one big index, could be better to create (for example) 4 smaller indexes?


Thanks

  1. Depending on the queries that will be run against these indexes, you may want to create partial indexes to reduce the size:
    https://docs.couchbase.com/server/current/learn/services-and-indexes/indexes/indexing-and-query-perf.html#partial-index

  2. The “resident ratio” for all indexes are at 0%. We recommend to keep indexes 20% for optimal functioning. For the indexes in the snapshot, there is 30GB of indexed data. The memory quota for index service should be assigned accordingly.

  3. In general, the index design is driven by the queries you need to execute. Please check https://index-advisor.couchbase.com/indexadvisor for guidance on optimal indexes for your queries.

Hi @Mauro_Sala ,
got your same issue and I found this solution: Index Partitioning | Couchbase Docs
The “partition by hash” clause should do the magic trick for you