I've prepare a test environment to try to find a way to fix this.
I have one machine with 16 cores and 64gb ram, with ES 5.6.8 and ES 6.2.4, each instances of ES have a XMX/XMS in 30 Gb
have only one index with 35.808.600 docs, 5 shards, codec: best_compression, _source: true, no stored_field's in both ES versions.
The Pri.Store.Size
in ES 5.6.8: 18,48 Gb
in ES 6.2.4: 12,20 Gb
why is this difference?
When perform the same aggregation in
ES 5.6.8 took: 358~530 ms
ES 6.2.4 took: 5200~12600 ms
why this happens?? what change in the mayor version than degrade the performance in this way??
i've compare all settings of ES cluster and index, and all are basically the same (using include_defaults=true to got defaults too)
the aggregation query is:
{
"query": {
"constant_score": {
"filter": {
"bool": {
"must": [
{ "range": { "timestamp_utc": { "gt": "now-30d" } } },
{ "terms": { "element_id": [
"68C894", "BE6053", ......... UNTIL TO 1000 ELEMENTS
] } } ] } } } },
"size": 0,
"aggs": { "by_element": { "terms": { "field": "element_id", "size": 999999 },
"aggs": { "by_topic": { "terms": { "field": "topic", "size": 999999 },
"aggs": { "by_group": { "terms": { "field": "group", "size": 999999 },
"aggs": { "by_type": { "terms": { "field": "type", "size": 999999 },
"aggs": { "by_sub_type": { "terms": { "field": "sub_type", "size": 999999, "missing": "N/A" },
"aggs": { "by_position": { "terms": { "field": "position_name", "missing": "N/A", "size": 999999 },
"aggs": { "by_position_id": { "terms": { "field": "position_id", "missing": "N/A", "size": 999999 },
"aggs": { "sent_sub_type": { "sum": { "field": "event_score" } } }
} }
} }
} }
} }
} }
} }
} }
}
Thanks by advance