Not All Items are Indexed

n1ql
index

#1

I’ve created an index (only on one field), I then imported 23m rows and indexing presumably finished but when I queried the data only a subset of records I knew should have come back did. There appears to be only 10m or so items indexed with around 13 m left (from total mutations remaining). How can I speed this up? It only seems to be going very very slowly?


#2

Increase Indexer memory. cc @deepkaran.salooja


#3

What is the couchbase version and index service memory quota? As @vsr1 suggested, increase the memory quota should help.


#4

up to 16g now, but will grinds to a halt almost it seems


#5

can you check what is the data size and average item size for the index from the UI graphs


#6

gave up on couchbase for now