This comprehensive 2-hour workshop is designed to guide you through the essential steps and considerations for a successful PostgreSQL to ClickHouse migration. This workshop will kick off with an introduction to the key reasons why migrating from PostgreSQL to ClickHouse can significantly enhance your data processing capabilities. We will delve into the main conceptual differences between the two databases, covering crucial aspects such as primary keys, partitions, and indexes.

In the second module, we will explore the initial steps of the migration process. You will learn how to understand your dataset, map PostgreSQL data types to ClickHouse equivalents, and define primary keys in ClickHouse. We will also cover the process of loading data into ClickHouse, ensuring a smooth transition. The final module will focus on data modeling strategies in ClickHouse, emphasizing denormalization, effective use of ClickHouse joins, and other advanced techniques to optimize performance and scalability. This workshop is perfect for database administrators, data engineers, and developers looking to leverage ClickHouse’s powerful analytical capabilities.

The material is presented in modules and will include:

Module 1: Introduction

• Why migrate from PostgreSQL to ClickHouse?
• Main conceptual differences
  • Primary keys
  • Partitions
  • Indexes

Module 2: Schema Design

• Understand the Dataset
• ClickHouse Data Types
• ClickHouse Primary Keys
• Load Data

Module 3: Data Modeling

• Denormalization
• ClickHouse Joins
• Other Techniques

Hosted by: Pablo Musa