Conference Schedule - PGConf.EU 2022

Pragmatic (non)native partitioning for developers on Postgres

Date: 2022-10-28
Time: 09:30–10:20
Room: Madrid
Level: Intermediate

As a developer I really want to know why and when I should care about partitioning my data in Postgres. In Adyen we have tables that span multiple terabytes and partitioning is one of our main tools to keep scaling on a single Postgres cluster. I would like to share some insights we discovered along the way on when and how to partition your big tables and new tables.

Can I use the new native partitioning available since Postgres 10 and what are my alternatives? What can I do for my existing tables that are not partitioned?

We will talk about pros and cons of partitioning based on real life experience on quite large legacy tables, as well as new projects.

Speaker

Antoine Daignan