Postgres Build 2021 has ended
Back To Schedule
Wednesday, December 1 • 2:25pm - 3:05pm
Table partitioning done right

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

This talk is out to dispel false myths about partitioning, like "partitioning will make all my queries faster" or "large table must be partitioned". In stead of these, I will show you how to use partitioning for your benefit.

We will review the different features of partitioning to put our reasoning on solid ground.

I will also talk about the limitations of partitioning and present traps that you should avoid.

To round off the talk, I will discuss how partitioning interacts with other database features.

avatar for Laurenz Albe

Laurenz Albe

Talking Head, Cybertec
Laurenz Albe has worked with and contributed to PostgreSQL and related projects since 2006.He is the principal author and maintainer of the Oracle Foreign Data Wrapper, ora_migrator, and pgreplay.He joined Cybertec in 2017, where he provides consulting, support, training, and custom... Read More →

Wednesday December 1, 2021 2:25pm - 3:05pm GMT