I mean using Clickhouse for time-series, of course.
I understand your point on adding a new feature to your already existing Postgres solution.
It's kinda what I do by using MySQL engine and dictionaries with Clickhouse, I assume.
Yes -- but slightly different, but without the network hop!
MySQL engine for Clickhouse sounds like dblink[0] or foreign data wrappers(fdw)[1] in Postgres. Doing it with Postgres allows for way more flexibility (the data could be local or remote) in this case, and the data will be at home in Postgres, with all the stability, features, operational knowledge (and also bugs/warts of course) that come with Postgres.
You may never get 100% of the performance you'd get from a purpose-built database that doesn't make the choices Postgres makes but the idea of getting 80/90% of the way there, with only one thing to maintain is very exciting to me.
