# Performance degradation after ES upgrade (v2.4 -\> v5.4)

**URL:** https://discuss.elastic.co/t/performance-degradation-after-es-upgrade-v2-4-v5-4/88305
**Category:** Elasticsearch
**Created:** [June 5, 2017, 5:12pm UTC](https://discuss.elastic.co/t/performance-degradation-after-es-upgrade-v2-4-v5-4/88305 "2017-06-05T17:12:30Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![alwag85](https://avatars.discourse-cdn.com/v4/letter/a/eada6e/32.png) [@alwag85](https://discuss.elastic.co/u/alwag85)
#### Post date: [June 5, 2017, 5:12pm UTC](https://discuss.elastic.co/t/performance-degradation-after-es-upgrade-v2-4-v5-4/88305/1 "2017-06-05T17:12:30Z")

</div>

I tried to migrate from Elasticsearch 2.4 to 5.4 and i experience a drop in percolator performance. Elasticsearch 2.4 percolator is 5-6 times faster than 5.3. For example:  
I have 25000 peroclators with term level queries and 5000 of them contain a wildcard queries.  
ES2.4: time of percolation 10 documents ~ 3 268 ms  
ES5.4: time of percolation 10 documents ~ 18 304 ms  
I think the problem is that the perculator cache was [removed](https://github.com/elastic/elasticsearch/issues/20555) . [The selecting of candidate percolator queries matches](https://www.elastic.co/guide/en/elasticsearch/reference/5.4/query-dsl-percolate-query.html#_how_it_works_under_the_hood) does not work well in my case. I can not refuse wildcard queries.  
Any ideas/suggestions for improving the current performance?

Thanks!

---

<div class="post-metadata">

### Author: ![mvg](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mvg/32/98890_2.png) [@mvg](https://discuss.elastic.co/u/mvg)
#### Post date: [June 20, 2017, 8:09am UTC](https://discuss.elastic.co/t/performance-degradation-after-es-upgrade-v2-4-v5-4/88305/2 "2017-06-20T08:09:46Z")

</div>

Hi @alwag85,

They only thing I can think of speeding this up right now is to increase the number of primary shards.

The selecting of candidate percolator queries doesn't support wildcard queries yet, but we may be able to add that support.

Martijn

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 18, 2017, 8:09am UTC](https://discuss.elastic.co/t/performance-degradation-after-es-upgrade-v2-4-v5-4/88305/3 "2017-07-18T08:09:52Z")

</div>

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