Schedule - PGDay/MED 2024
Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance
Date: 2024-12-05
Time: 10:20–11:10
Room: Positano
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. In this talk, I will explore the benefits of partitioning in PostgreSQL, including improved performance and simplified maintenance.
After introducing the benefits of table partitioning, I’ll discuss the different types of partitioning available in PostgreSQL, such as range, list, and hash partitioning, and highlight common use cases and trade-offs.
With practical examples, I’ll demonstrate how to implement declarative partitioning in PostgreSQL while maintaining transparency to the application. We will also discuss some key considerations and best practices when designing the schema for partitioning.
I’ll finish with a look at popular PostgreSQL extensions like TimescaleDB and Citus for similar workloads.
By the end of this session, you will be able to create partitioned tables in PostgreSQL that improve the performance and maintenance of your application, allowing you to scale with more control than ever before.