I still don't really understand your use case to suggest how to solve it - it doesn't seem like it should have to work like that but I don't really know. So wh

I still don't really understand your use case to suggest how to solve it - it doesn't seem like it should have to work like that but I don't really know. So why don'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's hard to beat ES/Solr/Lucene for text searches, but depending on what you need, Postgres' 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.