PostgreSQL and ClickHouse, Better Together

​A hands-on training on integrating PostgreSQL with ClickHouse to build high-performance analytical systems, migrating schemas and queries, and redesigning data models for analytics.

​Modules:

1. ​Introduction

2. ​Migrating data

3. ​Migrating queries

4. ​Change Data Capture (CDC)

5. ​Materialized views and projections

​By the end, you'll be able to explain OLTP vs. OLAP workload differences, redesign Postgres schemas for ClickHouse, migrate Postgres queries to efficient ClickHouse patterns, choose the right engines for updates and deletes, design CDC pipelines into ClickHouse, and optimize analytical workloads with materialized views and projections.