Postgres and ClickHouse on ClickHouse Cloud
Transactions and analytics both go to a Postgres database running on NVMe storage, with the pg_clickhouse extension. Native CDC replicates data from Postgres to a ClickHouse database for 100x faster OLAP.
Transactions
Analytics
Postgres database
pg_clickhouse
Transactional
ACID compliant
2x–10x faster
performance
NVMe
NVMe
NVMe
Native CDC
ClickHouse database
Columnar
100x faster OLAP