Evolution of Partitioning Features
Channel: Postgres Conference
Date: 07/06/2023

The Partitioning features in PostgreSQL is not something new. But it has matured over several years, release after release, especially the last 4 releases.
The evolutionary nature (small changes in each version) is often overlooked by users.
These small changes resulted in a build-up of a powerful Partitioning capability in PostgreSQL new versions. Now it is considered as capable of even replacing the worlds biggest database software even in Data Warehouses workloads.
Since there are no big announcements, surprisingly very few users are still not moved to native partitioning.
This talk starts with :
1. Short summary on the history of Partitioning
Then detailed look at 1. The birth of Native Declarative Partitioning and features and limitations
2. How PostgreSQL 11 addressed some of the very important missing pieces in Partitioning
3. How PostgreSQL 12 made a dramatic improvement in usability
4. PostgreSQL 13 and How it is ready to take on giants in the industry
5. PostgreSQL 14, Ever-evolving partitioning features.
This presentation is expected to create enthusiasm in the audience to drive towards the latest and most powerful features of Partitioning. Moreover, convince the importance of upgrading to the latest versions of PostgreSQL.
Small demonstrations are part of this presentation to highlight the importance of some of the new features.