I still don&#x27;t really understand your use case to suggest how to solve it - it doesn&#x27;t seem like it should have to work like that but I don&#x27;t really know.<p>So why don&#x27;t you use mongo your main data source and for the aggregations and use ES for the search (you just push changes to mongo when they update.)  It&#x27;s hard to beat ES&#x2F;Solr&#x2F;Lucene for text searches, but depending on what you need, Postgres&#x27; full text search may be fine.  Most use-cases where search is the need use some other datastore and just ES for the text searches.  Unless a text search is somehow part of the aggregation query..?  in any event - good luck.