PostgreSQL Partitioning - The New Legacy by Robert Treat

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.