After spending some time testing how to efficiently using primary and secondary indexes, where I keep adding / removing documents, I can see the index fragmentation percentage in the UI growing quite high - and the more it grow, the more the performance seems to degrade.
For example, at the moment, the UI report:
- 95.7% index fragmentation
- 9.15MB index data size
- 249MB index disk size
My expectation will be that the index compaction should kick off and sort out this - I can see the data compaction happening, but not the index compaction.
In the settings, index compaction is set to 30% - there are no tick next to it.
And the buckets do not override the default settings.
Am I missing something somewhere to make sure compaction happen?