Hi,
I have an elasticsearch cluster with 1.4.2. elastic version, 20 nodes with 16 GB, java 7 and 32 shards and I created another cluster with 1.7.0 elastic version, 20 nodes with 32 GB, java 8 and 32 shards.
I have a set of queries to compare the performance in both clusters. When I send queries with routing field the clusters performance is similar but when I send queries without routing (full on 32 shards), the first time both clusters are slow but the second time the cluster with 1.4.2 version is faster and the cluster with elastic 1.7.0 take a lot of time. It look like the elastic 1.7 cache doesn't work.
Times query without routing field:
Elastic 1.4.2
1st time: 521 ms
2nd time: 78 ms
Elastic 1.7.0
1st time: 1221 ms
2nd time: 1283 ms
Query:
{
"from" : 0,
"size" : 50,
"query" : {
"filtered" : {
"query" : {
"bool" : {
"must" : {
"term" : {
"from_id" : "1"
}
}
}
},
"filter" : {
"bool" : {
"must" : [ {
"range" : {
"period_date_created" : {
"from" : "now/d-20d",
"to" : null,
"include_lower" : true,
"include_upper" : true
}
}
}, {
"term" : {
"deleted_from_listing" : false
}
}, {
"terms" : {
"status" : [ "STATUS1", "STATUS2", "STATUS3", "STATUS4" ]
}
} ]
}
}
}
},
"sort" : [ {
"period_date_created" : {
"order" : "desc"
}
} ]
}
The filter cache doesn't have evictions.
Any ideas about that?
Thanks!