Postgres Traffic Cop! | Scaling Postgres 410

About this episode

This episode discusses controlling Postgres query traffic and related topics.

In this episode of Scaling Postgres, we discuss a proprietary way of controlling Postgres query traffic, preserving statistics during upgrades, a DB schema migration survey and a new repack command. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/410-postgres-traffic-cop/ 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

• Postgres query traffic control
• database schema migration
• Postgres upgrades
• repack command
• Postgres performance

Keywords

• Postgres
• query traffic
• database migration
• repack command
• performance

Mentioned in this episode

Organizations: 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