Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance
Presented by:

Ryan Booz
Ryan is an Advocate at Redgate focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA and product manager for more than 22 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!
As your database grows, the performance and maintenance of large tables can become challenging. Fear not! PostgreSQL has the right tool for the job: declarative table partitioning. This talk will discuss the benefits of partitioning in PostgreSQL, including improved performance and simplified maintenance.
After introducing the benefits of table partitioning, we’ll take a whirlwind tour through the range, list, and hash partitioning types available in PostgreSQL, highlight common use cases and trade-offs. From there, we’ll dive right into practical examples of declarative partitioning and discuss some key considerations and best practices when designing the schema for partitioning.
We'll finish by reviewing some practical 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:
- 2025 March 21 14:30 EDT
- Duration:
- 1 h 30 min
- Room:
- Gold Coast 3&4
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Essentials
- Difficulty:
- Medium