Mastering PostgreSQL Partitioning: Advanced Questions and Demos
Presented by:
Ryan Booz
Ryan is a Solutions Engineer at pganalyze. Ryan has been working as a PostgreSQL advocate, developer, DBA and product manager for more than 25 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.
Ryan is a long-time DBA, starting with MySQL and Postgres in the late 90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He’s at the top of his game when he's learning something new about the data platform or teaching others about the technology he loves.
No video of the event yet, sorry!
PostgreSQL partitioning continues to gain popularity and adoption. While many users understand the basics of creating partitions, they often seek practical guidance about their pros and cons, ideal use cases, and potential pitfalls.
In this follow-up session to "Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance," we'll explore partitioning strategies for different data types, examine maintenance tools like pg_partman, address default partition challenges, investigate how partitioning affects query planning and execution, review recent PostgreSQL improvements, and discuss methods for managing partition growth over time.
Partitioning is one of PostgreSQL's greatest strengths. Come learn how to use and manage it more effectively.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference: 2026
- Language:
- Track:
- Essentials
- Difficulty:
- Medium