Welcome to Percona Live Online 2021
Online Open Source Database Conference
Wednesday, May 12 • 14:00 - 15:00
Scaling Large Tables in PostgreSQL With Declarative Table Partitioning

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

When a table gets too large, performance and maintenance are heavily affected. Splitting the table into multiple partitions to achieve the desired performance.

Table partitioning has been supported in PostgreSQL for many years as a design pattern of table inheritance, which is complex to use correctly, and didn't benefit from any parallelism. Since PostgreSQL version 10, there is support for declarative table partitioning, having new features in improvements in later versions. Table partitioning is now much easier to use and there are more use cases covered. In this talk, we will review with concrete examples how you would benefit from table partitioning, how to use declarative partitioning, and what are the implications of taking some decisions when designing the schema.

avatar for Boriss Mejias

Boriss Mejias

Solution Architect, EDB
I'm a holistic system software engineer (aka Solution Architect), PostgreSQL consultant and trainer, free software user, and headbanger. I have been working with PostgreSQL since version 9.1. First, as part of my job related to other projects, and with full dedication since 2017... Read More →

Wednesday May 12, 2021 14:00 - 15:00 EDT
Room #3