Can query fetches be routed to a different database

Elastic Stack Elasticsearch
#1

From the the slow logs I see that index.search.slowlog.fetch and QUERY_AND_FETCH slow for queries. my understanding is this where the ES fetches the documents after it determines the ids in the QUERY phase.

I am thinking of keeping just ids in elasticsearch and move the document to redis , can i change elasticsearch to do the fetches from redis? or should I get back the ids from ES and then do a redis fetch?

#2

You cannot do that.
Why would you want to anyway?

#3

From the slow logs fetches seem slow, I am seeing this might be to do with disk IO so instead of storing the documents in disk in ES thought it will be better idea to use ES for searching /faceting/ filtering but the actual document fetch could be from in memory datastore

#4

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