This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2023

It's Not You, It's Me: Breaking Up with Massive Tables via Partitioning

Date: 2023-12-14
Time: 13:40–14:30
Room: Meridian

Similar to memory configurations and Active-Active, when you find yourself Googling "How to partition a Postgres table", you're usually in a tight spot. However, although real-life use cases for partitioning typically start with a large, production table where uptime is critical, most documentation and blogs only cover setting up new partitioned tables -- ignoring the delicate work necessary to migrate safely with minimal downtime.

This talk actionably addresses that knowledge gap: covering multiple ways to partition large, production tables.

This talk will discuss: - Basic Postgres partitioning internals - Choosing between partitioning strategies (with examples) - Rules of thumb, and when NOT to partition - Methods of migrating a live, production table to a partitioned table (with examples and demo code) - Partitioning observability and maintenance


This session has been made available on:


The following slides have been made available for this session:


Chelsea Dole