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

[alwag85 (Alexander)]

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 . The selecting of candidate percolator queries matches does not work well in my case. I can not refuse wildcard queries.
Any ideas/suggestions for improving the current performance?

Thanks!

[mvg (Martijn Van Groningen)]

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