Sorting on large index

Elastic Stack Elasticsearch
1

Hi!

I read about index sorting in the documentation, but I don't know what are the limits and if there's any downside to do it. For example, I have a daily index with around 500M documents. I'd sort it by 5 fields from very low (100-200) cardinality to very high (potentially million).
How does this affect the indexing time? How many fields can I use? Should I omit very high cardinality fields even if those are frequently searched?

Thanks!

2

This blog post discusses overhead and the impact on indexing performance, which it can be substantial. I think it primarily makes sense for search heavy use cases where the additional work at indexing time is a good trade-off.

1 Like
3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.