[adra]

If you're not interested in fast full text search, then you're wasting a ton of resources on a solution that can be served way easier on more specially tuned analytics databases. The entire storage and retrieval methodology of these engines are based largely to do lucene style searches at extreme speeds.

[suction]

What would be a good self-hostable solution to replace ES aggregations? I'm also quite fond of Clickhouse which is a lot faster yet, but the sheer number of products which have popped up in the last decade always makes me wonder if there's still faster solutions out there.

[adra]

We're using a lot of clickhouse but there's influxdb (they apparently have a SAAS version now too), but you can look at druid or even the Hadoop family of products. The latter two are probably more in line with building entire analytics workflows instead of just a storage tier. If you're looking for more workflow managed solution, you can also look into apache flink which has a lot of similar uses

[suction]

Thank you. I think I'll try to get the most out of Clickhouse, also because of the extremely ease of maintaining it and keeping it running.