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.
- Rules, Constraints, Inheritance and how it all comes together.
- When and why to use triggers for partitioning.
- Automated partition maintenance.
Learn how to setup and maintain table partitioning in PostgreSQL with hands on examples. We'll walk through manipulating SQL, writing rules and trigger, and show you how you can use plpgsql to automate your partition maintenance.