Evolution of Partitioning Features in PostgreSQL - A super charged elephant

Important milestones in Partitioining features and how it evolved over a time to become one of the most powerful feature.

Presented by:

2f06ebff71823abb213c4b64a86b9557

Jobin Augustine

Percona

Jobin Augustine is a PostgreSQL expert and Open Source advocate and has more than 18 years of working experience as consultant, architect, administrator, writer, and trainer in PostgreSQL, Oracle, and other database technologies. He has always been an active participant in the Open Source communities and his main focus area is database performance and optimization. He is a contributor to various Open Source Projects and is an active blogger and loves to code in C++ and Python.

Jobin holds a Masters in Computer Applications and joined Percona in 2018 as a Senior Support Engineer. Prior to joining Percona, he worked at OpenSCG for 2 years as Architect and was part of the BigSQL core team, a complete PostgreSQL distribution offering. Previous to his work at OpenSCG, Jobin worked at Dell as Database Senior Advisor for 10 years and 5 years with TCS/CMC.

No video of the event yet, sorry!

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.

Date:
2021 December 14 13:00 EST
Duration:
1 h
Room:
Online
Conference:
2021 Postgres Conference Webinars
Language:
Track:
Ops
Difficulty:
Medium
Requires Registration:
Yes (Registered: 17)