Hi,
I am migrating an entity centric index from ES 2.3 to ES 6.0 and in ES 6.0, _ttl is deprecated. I originally was planning on using rolling indices but it won't work for us well since routing logic is complex for my use case.
So the question here is this: if I am using a single index with DELETE_BY_QUERY/force merge operations to handle deleting old documents, will it work with index sorting where I sort by a field lastUpdateTime and then delete if lastUpdateTime is past a certain time? In particular, will the DELETE_BY_QUERY operation come to early termination?
And does anybody have actual benchmarks for searching on rolling indices vs a single index?
Index sorting: https://www.elastic.co/blog/index-sorting-elasticsearch-6-0