Cloudflare documented their PostgreSQL to ClickHouse journey here: https://blog.cloudflare.com/http-analytics-for-6m-requests-per-second-using-clickhouse/ https

Cloudflare documented their PostgreSQL to ClickHouse journey here: https://blog.cloudflare.com/http-analytics-for-6m-requests-per-second-using-clickhouse/ https://blog.cloudflare.com/http-analytics-for-6m-requests-p... It covers a lot of the scaling bottlenecks in their original PG-based pipeline and how they eliminated them. (Disclaimer: I work on ClickHouse.)