Support Partial Indexing
We have a large collection but would only like to index the most recent entries, which would reduce the amount of space and resources it would take to index and query.
This would be strongly needed. The current workaround is to create a separate collection, but then we cannot use a $out stage to populate it without destroying the index as said here:
We are currently solving with a $merge stage but a partial index would be definitely a better solution.
We dont want this data to be searchable with mongo search, but searchable with mongodb basic indexing. Mongo Search index performance will be much better if we can have this option and keep old data to be retriever with mongot index.
Today, you may be able to move documents in a collection that you do not want searchable to online archive.
Jonathan Gautier commented
Any news about this feature ? We have more than 100 millions documents and only 600k public searchable. This can improuve the performance without upgrading server.
In several collections, we have tens of millions documents, but only 1-5 million are public/searchable in any given collection. It seems tragic to index all 50 million documents when only 5 million are public.