Hands-on workshop · Sydney

Build a unified data stack for real-time AI with Postgres and ClickHouse.

The software and AI industry has landed on the best-of-breed data stack. Postgres powering transactional workloads, ClickHouse powering analytical workloads, each doing what it is best suited for. Spend a morning building that stack yourself, at the keyboard.

Free To Attend Sydney, Tues 13th Oct 9:00am – 12:30pm AEDT The Work Club, 200 George St
06 Modules
3.5 Hours, instructor-led
07 Learning outcomes
Free To attend, places limited
Overview

Two engines. One best-of-breed stack.

Tens of thousands of companies now run Postgres and ClickHouse to support their data stacks. Postgres carries the transactional workload, ClickHouse carries the analytical one. This workshop is about the join between them.

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.

The session covers how ClickHouse's new enterprise-grade Managed Postgres was built for performance and scale. It also introduces strategies for handling updates and deletes, implementing change data capture from PostgreSQL, and optimising 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.

The curriculum

Six modules across the morning.

The material is presented in modules, each building on the last, with guided labs throughout.

01
Introduction.
02
Managed Postgres.
03
Migrating data.
04
Migrating queries.
05
Change data capture (CDC).
06
Materialised views and projections.
Postgres for OLTP alongside ClickHouse for OLAP
Your instructor

Session led by

Victor Isakov
Victor Isakov
Senior Curriculum Developer & Instructor ClickHouse
What you'll learn

What you'll be able to do afterwards.

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

The unified data stack

One stack for transactions and analytics.

The pairing at the centre of this workshop is now a managed product. Postgres managed by ClickHouse delivers fast, scalable, enterprise-grade Postgres, natively integrated with ClickHouse: one stack for transactions and analytics, built for real-time and AI-driven applications, with no added complexity.

Explore Postgres managed by ClickHouse →
01 · Performance
NVMe-backed Postgres.

Enterprise-grade Postgres on local NVMe storage: microsecond disk latency, consistent performance without network jitter, and up to 10x faster I/O-heavy workloads with no throttling or limits.

02 · Integration
Native ClickHouse integration.

Native CDC syncs Postgres data to ClickHouse in a few clicks, with replication latency measured in seconds. pg_clickhouse provides a unified query layer across transactions and analytics, with comprehensive query pushdown.

03 · Reliability
Enterprise grade, built with Ubicloud.

Built for mission-critical workloads: high availability with up to two standbys, automatic backups with WAL archival, forks and point-in-time recovery, and end-to-end encryption with private networking.

04 · Openness
Open source, end to end.

Every component is open source: Postgres for transactions, ClickHouse for analytics, PeerDB for CDC, and pg_clickhouse for the query layer. No vendor lock-in, full control of your data stack.

Before you arrive

Three things to set up in advance.

The labs start early in the morning. Getting these done beforehand means you spend the session working rather than signing up.

01 · Course materials
A ClickHouse Academy account.

During the training you will access your course materials in ClickHouse Academy. It is recommended that you create an account before the event at learn.clickhouse.com.

02 · Lab access
A ClickHouse Cloud account.

Needed to access the labs. Sign up at console.clickhouse.cloud.

03 · Compute
A ClickHouse Cloud service.

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.

The session

One morning. One city.

Register below and we'll confirm your place and send joining details.

Sydney Tuesday 13th October 2026
Free to attend
Time9:00am – 12:30pm AEDT
VenueThe Work Club, Level 32, 200 George St, Sydney NSW 2000
FormatInstructor-led training with hands-on labs. Bring a laptop.
CostFree. Places are limited.
Reserve a place
"

Postgres and ClickHouse. Each doing what they are best suited for.

ClickHouse × Innovatus Media
Your hosts

ClickHouse is the fast, open-source, column-oriented database powering real-time analytics and agentic systems with millisecond queries at petabyte scale. Paired with Postgres, it forms the de facto data stack for AI-powered applications, trusted by teams at Meta, eBay, Microsoft, Spotify, and thousands of others.

Connecting Innovation. Innovatus Media partners with global technology companies to connect C-Suite leaders around the world with new ideas, ways of working, and technologies. Innovatus' events are built on peer-to-peer collaboration, are private discussions, and are delivered with a lot of humility and informal energy.

Register your interest

Reserve your place.

Places are limited and allocated in order of registration. Complete the form below and the Innovatus Media team will be in touch to confirm your place and send joining details.

Places are limited. Registering does not guarantee a seat, we will confirm by email.

Questions before you commit?

If you would prefer to talk it through first, or want more detail on the labs before registering, the team is happy to help.

Email the team WhatsApp the team Before you arrive