My Postgres partitioning cookbook | POSETTE: An Event for Postgres 2026

Microsoft Developer
AI summary

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.