0

I have a single node dedicated for ES server. We have indexed around 25 GB Data in it.

I am using a bool query to fetch data and it takes around 6-7 minutes to give the results.

The RAM on the node is just 1 GB. I understand that the RAM and other hardware parameters needs to be increased.

But apart from hardware improvements, is there any thing else that I can do?

Updated: Below is the mapping of my index: Below is the mapping of my index:

:index=>index_name,
        :body=>{
          :mappings=>{
            :texts=>{
              :properties=>{
                :file_number=>{:type=>"long"},
                :text=>{:type=>"string",:term_vector=>"with_positions_offsets_payloads"}
              }
            }
          }
        }

Below is the query used :

:body=>{
        :query=>{
        :bool=>{:minimum_should_match=>1,
        :should=>[{:query_string=>{:query=>"master agreement", :default_field=>"text"}}
                 ,{:query_string=>{:query=>"master agreement", :boost=>2, :default_field=>"text", :default_operator=>"AND"}}
                 ]
               }
                },
         :fields=>["file_number"], :size=>393413, :from=>0
       }

I am not using pagination. I am scanning across the full set

Please let me know

Vipul Kumar
  • 259
  • 1
  • 2
  • 12

0 Answers0