I'm having an index of around 140M entries, still running elastic 1.3 in production and using filtered queries to do lookups, most of the queries execute in sub 100ms, between 40 and 100ms.
I now have a new server with almost the same hardware specs and upgraded to 2.0.
I followed the guidelines that were posted here: https://www.elastic.co/blog/better-query-execution-coming-elasticsearch-2-0
The query I'm running is :
And first hit is around 900ms all subsequent ones take around 230ms
I'm a bit dissapointed with this not so "fast" speed. .
Are there any things I can optimize further to this query or things you see I'm doing wrong with it?
I just want to make sure I'm making full use of the Roaring bitmaps and that is everything is wrapped in constantScore.
This is the explain of some of the results: