I have upgraded Elasticsearch 5.5 to 7.7 recently.
I have only 1 index of 30 fields and 6K data. Dataset is very simple in nature. [provided 1g memory in jvm options]
In the dataset i have a field
description which has text around
I am using a search query having combination of
bool, must, query_string, term.
When I perform a search operation for exact indexed description having 250 chars, search query takes long time to respond [15 sec] and Elasticsearch gets crashed.
If I use small search term of 20-25 chars ES works well.
All the words in search term are fuzzy term, we have appended ~ at end of each word.
In ES 5.5 above scenario was working pretty well with no issue and looks like something has broken in ES 7.7
- Could you please suggest how should I proceed on my issue?
- Is there any limit to input search term ?
- How much memory should I set in development and production ?