Begining in 8.1, PostgreSQL has offered table partitioning, allowing you to split data across different physical segments for significant performance improvements. Until recently not much had changed, but starting in Postgres 10, and new, more native partitioning system was added into Postgres. While the initial implementation left some things to be desired, many of those issues are being addressed. This talk will cover many of the insider tricks that are used in large setups and explain the trade-offs between the options you now have available.
Presented at PGCon 2018
