Elastic search percolator scalability issues

I am running a 4 data node + 2 master node cluster and have created an index to store search queries. In the percolator I store regexp based search queries.
When I run a percolate search passing a document, I see the latency of search/match being very high (~500ms). I have only stored very few (<10) search queries in percolator index but the search latency seems to be at very unacceptable levels.

any thoughts on this?

My index mappings is given below

{"settings":{"number_of_shards":5,"number_of_replicas":1},
"mappings":{"_doc":{"properties":{"createTime":{"type":"long"},"query":{"type":"percolator"},"user":{"type":"nested","dynamic":"true","properties":{"id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"key":{"type":"keyword"}}}}}

I store regexp based search queries

I believe that this is the main cause. Regexp queries are slow.

1 Like

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