The Hallway Track
Engineering Insights

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

Microsoft Developer (Build) · Jun 18, 2026 · Engineering Insights

A practical guide arguing range-based partitioning is the only good way to partition large Postgres tables.

“If your tables are around 100 gigabytes, that's a good moment to start to think about partitioning.”

A conference talk by Derk van Veen shares a Postgres partitioning cookbook, recommending range-based partitioning over hash or list approaches and starting at ~100GB table size. It is a database engineering talk with no meaningful AI industry signal.

postgres database partitioning data-engineering

Watch / read the original source →