---
title: "PostgreSQL and ClickHouse, Better Together"
date: "2026-08-25"
time: "11:30"
timezone: "Asia/Singapore"
location: "Zoom (Virtual)"
category: "Virtual training"
---

# PostgreSQL and ClickHouse, Better Together

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

**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<br>
**Module 2**: Migrating Data<br>
**Module 3**: Migrating Queries<br>
**Module 4**: Change Data Capture (CDC)<br>
**Module 5**: Materialized Views and Projections<br>

**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](https://learn.clickhouse.com). 
- 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.