Elastic Cluster Good Configuration for better performance

Hi Team,

Please help me with good configuration for the cluster to improve the performance.

My requirement was :-
we are using Cluster 7.9.1

  We have an employee table which has around 30 columns and total records in this table are around 30million records.
select * from employee where id= '12345';

QueryBuilders.matchQuery("id", "12345");
QueryBuilders.termQuery("id.keyword", "12345");

I have used matchquery /termquery to replace above query in my API..but using both didnt have much difference.

If the above implementation is good , should we check on the configuration side to increase performance

To hold some n million/billion of records. ( Around 50-60GB) what should be the 
1. configuration of cluster, 
2. number of nodes, 
3. what is the heap memory, 
4. CPU Cores ?
5. Number of shard in index ?
6. Do we need to use replicas in index ? 


Thanks,Preformatted text``Preformatted text

Your query is good. I'd prefer using a term query.

May I suggest you look at the following resources about sizing:


And https://www.elastic.co/webinars/using-rally-to-get-your-elasticsearch-cluster-size-right

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