Schedule - PgDU 2019

Table Partitioning in PostgreSQL

Date: 2019-11-15
Time: 13:00–13:40
Room: Conference Room
Level: Intermediate

Recent releases of PostgreSQL have added powerful new table partitioning features. These features allow for effective management of larger data sets and introduce a number of new concepts.

The talk is suitable for all users of PostgreSQL and will cover:

  • Common problems managing very large tables
  • Partitioning strategies: LIST, RANGE, HASH
  • How partitioning can help
  • Partition pruning
  • Partition management
  • Partition-wise joins
  • Partition-wise aggregation
  • Indexing and constraints
  • Foreign keys
  • Foreign partitions
  • Partition performance considerations
  • Possible future improvements


The following slides have been made available for this session:


David Rowley