To be clear, I love Postgres. We use Postgres as our app db. But clickhouse is hands down better for analytical workloads[0] (think aggregate queries over a bil

To be clear, I love Postgres. We use Postgres as our app db. But clickhouse is hands down better for analytical workloads[0] (think aggregate queries over a billion rows). > Clickhouse sucks when you need data integrity, primary key can be duplicated. People use MergeTree engine to dedupe, but even so, dedupe doesn't guarantee the absence of duplication primary key. So at query time you have to call Aggregate Function. Agreed. Fortunately we control the processes that insert data and can handle these issues during ingress. > But good thing is ClickHouse has amazing integration with Postgres such as replication through logical replication, foreign data wrapper so you can query Postgres table inside Clickhouse Yes! This was surprisingly easy. We set up a way[1] for users to connect their pg data in Luabase. 0 - https://tech.marksblogg.com/benchmarks.html https://tech.marksblogg.com/benchmarks.html 1 - https://luabase.notion.site/Postgres-c6abe018218d49348ad754982ac4ee25 https://luabase.notion.site/Postgres-c6abe018218d49348ad7549...