Indexes with different shards, diffent responce time for same query

Hi Guys,

First of all thanks for taking the time to read my topic.
I have create two indexex:
First one: has 7 shards and the second has 4.

Basically I did a reindex from test_2 to test_3 so they contain the same documents and the same mappings. Could someone let me know why the same query takes much more on the second index test_3?

The query is a terms query with 5 inner terms on to another.
Basically in the first index it take less than a second will on the second it take about 4 seconds to execure
I have forgedSegments to 1 to both of the indexes.

The query more specifically is

GET test/_search?size=10000
{
  "aggs" : {
  	"countries" : {
      	"aggs" : {
          	"countryName": {
              	"terms": {
                  	"field": "countryName"
              	},
              	"aggregations": {
                  	"region": {
                      	"terms": {
                          	"field": "region"
                      	},
                      	"aggregations": {
                          	"municipality": {
                              	"terms": {
                                  	"field": "municipality"
                              	},
                              	"aggregations": {
                                  	"town": {
                                      	"terms": {
                                          	"field": "town"
                                      	},
                                      	"aggregations": {
                                          	"postalCode": {
                                              	"terms": {
                                                  	"field": "postalCode"
                                              	}
                                          	}
                                      	}
                                  	}
                              	}
                          	}
                      	}
                  	}
              	}
          	}
      	},
      	"date_range": {
          	"field": "@timestamp",
          	"ranges": [
              	{ "from": "1123164501234", "to": "1123265505678" }
          	]
      	}
  	}
  }
}

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