Repack Concurrently | Scaling Postgres 414

About this episode

This episode discusses repack concurrently in PG 19, schema design, hints, and enforcing constraints across partitions.

In this episode of Scaling Postgres, we discuss repack concurrently coming to PG 19, how to design your schema, all about hints and enforcing constraints across partitions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/414-repack-concurrently/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

People in this episode

Host: Creston Jamison

Topics covered

• repack concurrently
• Postgres performance
• schema design
• hints
• constraints
• partitions

Keywords

• repack concurrently
• PG 19
• schema design
• Postgres performance
• constraints
• partitions

Mentioned in this episode

Organizations: PG 19, Postgres, Scaling Postgres, Postgres Performance Demystified

More episodes of Scaling Postgres

• Postgres 19 Beta 1 Released | Scaling Postgres 420 · June 7, 2026 · 19 min
• The Dynamic Duo? | Scaling Postgres 419 · May 31, 2026 · 16 min
• Multigres Architecture | Scaling Postgres 418 · May 24, 2026 · 17 min
• 11 Security Issues | Scaling Postgres 417 · May 17, 2026 · 20 min
• Zero Bloat Postgres Queue | Scaling Postgres 416 · May 10, 2026 · 15 min
• pgBackRest Is Dead? | Scaling Postgres 415 · May 3, 2026 · 16 min