Loading…
Attending this event?
Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!
Back To Schedule
Wednesday, May 12 • 14:00 - 15:00
Scaling Large Tables in PostgreSQL With Declarative Table Partitioning

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Video will become available 10 minutes before session start


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.

Speakers
avatar for Boriss Mejias

Boriss Mejias

Solution Architect, EDB
I'm a holistic system software engineer (officially known as Solution Architect), PostgreSQL consultant and trainer, free software activist, 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... Read More →


Wednesday May 12, 2021 14:00 - 15:00 EDT
Room #3
Feedback form isn't open yet.