Postgres to ClickHouse: Data Modeling Tips

Re:Postgres to ClickHouse: Data Modeling Tips by benwilson-512 on Saturday July 19, 2025 @06:48PM (#44620160)

We have been doing exactly this at CargoSense! We have gotten very far on just Postgres but as our BI and other analytics queries have gotten more complex and our scale of “business tables” grown 20x over the last 18 months it just wasn’t cutting it anymore.

The CDC to Clickhouse flow has been very fast and reliable, and then for us at least setting up some incremental materialized views that set up what we need for reporting has been perfect. Clickhouse’s storage efficiency has been mind boggling.

[ Parent | on HN ]

Re:Postgres to ClickHouse: Data Modeling Tips by another_twist on Sunday July 20, 2025 @01:13AM (#44622175)

I'd be interested in the workload numbers when postgres croaked and you considered clickhousr instead .

[ Parent | on HN ]

Re:Postgres to ClickHouse: Data Modeling Tips by Incipient on Sunday July 20, 2025 @02:02AM (#44622376)

Very keen. Also the types of queries you ran into issues.

[ Parent | on HN ]