My Postgres partitioning cookbook | POSETTE: An Event for Postgres 2026
Postgresql Postgres partitioning Database partitioning Postgresql tutorial Database performance Sql Database architecture Postgresql catalog Postgres inheritance Database best practices
A practical guide sharing 3 years of PostgreSQL partitioning lessons from Adyen. Covers partition basics including index and foreign key creation, common pitfalls like catalog corruptions during data cleanup, default partition challenges, and advanced catalog manipulation techniques. Ideal for developers implementing or maintaining PostgreSQL partitioned tables in production environments.