Get the latest tech news
Postgres to ClickHouse: Data Modeling Tips
Dive into how Postgres-to-ClickHouse replication works, and learn best practices for data deduplication, custom ordering keys, optimizing JOINs, denormalization, and more.
If refreshable materialized views don't work due to the scale of data, here are a few recommendations you can follow to define custom ordering keys on larger tables and overcome deduplication-related issues. The query runs only on newly inserted rows rather than scanning the entire source table, making it a suitable choice for massive datasets, including those in the petabyte range. Replicating analytical data from PostgreSQL to ClickHouse with Postgres CDC is an efficient way to scale your business, enabling real-time analysis of large datasets.
Or read this on Hacker News