Repack Concurrently | Scaling Postgres 414

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.

Content Discussed

• Waiting for PostgreSQL 19 – Add CONCURRENTLY option to REPACK
• Understanding PostgreSQL REPACK Through repack.c
• Schema design checklist
• Hints, Part 1: The State of the Art Everywhere But Here
• Hints, Part 2: Features We Do Not Want
• Hints, Part 3: Advice, Not Orders
• Async I/O in PostgreSQL 19: The Year After
• Enforcing Constraints Across Postgres Partitions
• How Postgres CTIDs Gave Me a 30x Speedup on Processing 200 Million Rows
• When upserts don't update but still write: Debugging Postgres performance at scale
• Give Us Access, Already
• Approaches to tenancy in Postgres
• Postgres in Production, Special Series: Deep Dive into pg_stat_statements (Part 1)
• PostgreSQL MVCC, Byte by Byte
• The Postgres Performance Triangle
• PostgreSQL 19: Importing statistics from remote servers
• PostgreSQL 19: Online enabling of data checksums
• Polish configuration for TSearch
• Introducing the AI DBA Workbench: PostgreSQL Monitoring That Diagnoses, Not Just Reports
• pgrust: Rebuilding Postgres in Rust with AI
• All your GUCs in a row: allow_alter_system
• All your GUCs in a row: allow_system_table_mods
• All your GUCs in a row: allow_in_place_tablespaces
• Finding invisible use-after-free bugs in the PostgreSQL planner
• Contributions for week 15, 2026
• Supabase is now ISO 27001 certified
• Ring’s Billion-Scale Semantic Video Search with Amazon RDS for PostgreSQL and pgvector
• Aurora Serverless: Faster performance, enhanced scaling, and still scales down to zero
• Deploy Postgres and MySQL databases with PlanetScale + Workers
• How to Use the pgEdge Control Plane: From Zero to Multi-Master and Beyond
• Moving from Row Deletes to Instant Data Retention
• Write Amplification in Postgres: The 3-4x Tax on Every Insert
• Yes, You Can Do Hybrid Search in Postgres (And You Probably Should)
• Ignition and TimescaleDB: the Perfect Pairing
• TimescaleDB 2.26: 3.5x Faster time_bucket() Aggregations, 70x Faster Summary Queries, and Faster Multi-Column Lookups

YouTube Video

Podcast Audio