PostgreSQL partitioning. Work In Progress.
summary
Covers PostgreSQL native table partitioning (introduced in PostgreSQL 10) and compares it concretely with third-party extensions pg_pathman and pg_partman to identify missing functionality in core. Also outlines partitioning-related features under development targeting PostgreSQL 14, describing planned improvements and optimizations.
AI-written summary · about
related talks
23mPostgres Partitioning Best Practices
30mPostgreSQL Partitioning: Slicing and Dicing for Performance and Easier Maintenance
31mPostgres Partitioning Best Practices
34mPartitioning and Data Migrations Using PostgreSQL as an Example
34mPartitioning and Data Migrations Using PostgreSQL as an Example
42mBeginner's Guide to Partitioning vs Sharding in Postgres
26mMy Postgres partitioning cookbook
26mPartitioning your Postgres tables for 20x better performance