PostgreSQL and ClickHouse, Better Together

Date: Tuesday, August 24, 2026
Time: 11:30AM SGT
Duration: 3 hours
Location: Virtual - Zoom Webinar
Cost: FREE
Format: Instructor-led training with hands-on labs

What you’ll learn: In this hands-on training, participants will learn how to integrate PostgreSQL with ClickHouse to build high-performance analytical systems. Participants will migrate schemas and queries from PostgreSQL to ClickHouse, redesign data models for analytical workloads, and apply ClickHouse features such as denormalization, efficient primary keys, and specialized functions. The session also introduces strategies for handling updates and deletes, implementing Change Data Capture (CDC) from PostgreSQL, and optimizing analytical queries using Materialized Views and Projections. Through a series of guided labs, learners will build a practical understanding of how PostgreSQL and ClickHouse can work together to support both transactional and analytical workloads.

By the end of this module, learners will be able to:

• Explain OLTP vs OLAP workload differences
• Redesign Postgres schemas for analytical use in ClickHouse
• Migrate Postgres queries to efficient ClickHouse patterns
• Choose appropriate engines and features to handle updates and deletes
• Design and operate Change Data Capture (CDC) into ClickHouse
• Optimize analytical workloads using Materialized Views and Projections

The material is presented in modules and will include:

Module 1: Introduction
Module 2: Migrating Data
Module 3: Migrating Queries
Module 4: Change Data Capture (CDC)
Module 5: Materialized Views and Projections

Prerequisites:

• During the training, you will access your course materials in ClickHouse Academy. It is recommended that you create an account before the event HERE.
• ClickHouse Cloud account to access the labs
• You will also need to spin up a Clickhouse Cloud Service. If you have already used up your free trial, please contact us at least one day before the training.