Schedule - PGConf NYC 2023

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

Date: 2023-10-04
Time: 10:40–11:30
Room: The Forum
Level: Intermediate
Feedback: Leave feedback

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 seeks to actionably address that knowledge gap by covering how to partition existing production datasets.

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


The following slides have been made available for this session:


Chelsea Dole