I run some tests with aggregation. I have two types of data ("business" and "meta" types), that I can query separatly, but also combine them with parent-child queries.
The data for my "business" type doesn't change very often, but my "meta" data can change very frequently.
I want to run an aggregation on a field that belongs to the "business" type. But sometimes, the performance is not good enough because, I think, Elasticsearch has to rebuild the global ordinal cache every time a refresh is triggered for a meta document update. (I have an average value of 400 ms, which is good, but I can have peak of 20000ms when a refresh is triggered). It is a pity because, If I understand well, when I do "meta" types update, the global ordinal for my "business" field is still valid, and Elasticsearch doesn't have to recompute it.
Does anybody have any idea how to deal with my issue?