PGCon2007 - Confirmed

PGCon 2007
The PostgreSQL Conference

Robert Treat
Day 3
Room SITE A0150
Start time 11:30
Duration 01:00
ID 41
Event type Workshop
Track Performance
Language English

PostgreSQL Partitioning

Slicing and dicing your schema for quicker queries and dishing data

Begining in 8.1, PostgreSQL has offered table partitioning, allowing you to split data across different physical segments for significant performance improvements. While the feature is simple to get into, manageing large table partition setups can prove tricky to the beginer. In this tutorial we will discuss many of the insider tricks that are used in todays largest setups and talk about what the documentation leaves out.

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.