It’s Not You, It’s Me: “Breaking Up” With Massive Tables via Partitioning

It’s Not You, It’s Me: "Breaking Up" With Massive Tables via Partitioning


January 18, 2024    
6:00 pm - 8:00 pm


2201 6th Ave, Seattle, WA

Event Organizer

Seattle Postgres User Group

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

Pizza is provided, and we also have a user group lending library of books & papers related to PostgreSQL and Databases.

For directions (including where to park), look at this photo album:

Poster for the Spring 2024 Series of meetups: