Covers Postgres Partitioning including changes in Postgres 10 and 11
Mar '18,
Pasadena, California
PostgreSQL table partitioning allows you to scale your data to significantly larger volumes than would otherwise be possible. Getting started with table partitions in and of itself is not complicated, but if you want to get maximum benefits from your setup you can't just follow the documentation. This talk will walk through the ins and outs of table partitioning including:
What table partitioning is, and how it is implemented in PostgreSQL.
Inheritance, Constraints, Triggers, and how it all comes together.
Partition maintenance.
Learn how to setup and maintain table partitioning in PostgreSQL with hands on examples. We'll walk through manipulating SQL, writing triggers, and how you can automate your partition maintenance.