Build a unified data stack with Postgres and ClickHouse

Date:Tuesday, October 6, 2026
Time: 1:00 PM - 4:00 PM NZDT
Duration: 3 hours
Location: Makorā Toru, Precinct Flex Level 2, PwC Tower, 15 Customs St West, Auckland

FREE Instructor-led training with hands-on labs

The software and AI industry has landed on the “best-of-breed” data stack. There are 10s of thousands of companies using Postgres and ClickHouse to support their data-stacks.

Postgres powering transactional workloads and ClickHouse powering analytical workloads. Each doing what they are best suited for.

What you’ll learn: In this hands-on training, participants will learn how to host and 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 denormalisation, efficient primary keys, and specialised functions.

This session will cover how ClickHouse’s new enterprise-grade Managed Postgres was built for performance and scale.

The session also introduces strategies for handling updates and deletes, implementing Change Data Capture (CDC) from PostgreSQL, and optimizing analytical queries using Materialised 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.
• Host Managed Postgres in ClickHouse.
• 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.
• Optimise analytical workloads using Materialised Views and Projections.

The material is presented in modules and will include: Module 1: Introduction Module 2: Managed Postgres Module 3: Migrating Data Module 4: Migrating Queries Module 5: Change Data Capture (CDC) Module 6: Materialised 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.