Postgres Traffic Cop! | Scaling Postgres 410

Postgres Traffic Cop! | Scaling Postgres 410

Author: Creston Jamison March 30, 2026 Duration: 12:12
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/

If you're working with PostgreSQL, you know that growth brings a unique set of challenges. Scaling Postgres, hosted by Creston Jamison, is a weekly resource dedicated to navigating those exact hurdles. This isn't about abstract theory; it's a practical guide focused on extracting the best performance and building a resilient architecture as your data and user demands increase. Each episode serves as curated insight, distilling valuable information from across the web into actionable advice tailored for developers and engineers. The discussion consistently centers on how your specific application design and usage patterns are the fundamental levers for optimization. You'll hear clear explanations on configuration tuning, indexing strategies, replication, and managing bottlenecks-all through the lens of real-world scalability. Tune in to this technology podcast for a focused, developer-centric conversation that helps you build with confidence, ensuring your database infrastructure is robust, efficient, and ready for what's next.
Author: Language: English Episodes: 100

Scaling Postgres
Podcast Episodes
Move Off Of RDS? | Scaling Postgres 369 [not-audio_url] [/not-audio_url]

Duration: 18:01
In this episode of Scaling Postgres, we discuss why and how you could move off of AWS RDS, Snowflake acquires Crunchy Data, reducing your SQL queries and a novel way to migrate to partition tables. To get the show notes…
4 Times Faster UUID Primary Keys | Scaling Postgres 368 [not-audio_url] [/not-audio_url]

Duration: 19:10
In this episode of Scaling Postgres, we discuss the benefits of using time-based UUIDv7 vs UUIDv4 for primary keys, how OpenAI uses Postgres, handling locks and methods to migrate to partition tables with low downtime. T…
How Often Does That Query Run? | Scaling Postgres 367 [not-audio_url] [/not-audio_url]

Duration: 13:10
In this episode of Scaling Postgres, we discuss a Postgres VS code extension, service definition files, undead tuples and the benefits of finding out how often a query is run. To get the show notes as well as get notifie…
20,000 Times Faster Order By Limit | Scaling Postgres 366 [not-audio_url] [/not-audio_url]

Duration: 14:46
In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times faster query by fixing an order by limit iss…
Here Comes Async I/O! | Scaling Postgres 365 [not-audio_url] [/not-audio_url]

Duration: 20:01
In this episode of Scaling Postgres, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovative ways to optimize queries. To get the show notes as well as get notified of new…
Scaling For High Volume | Scaling Postgres 364 [not-audio_url] [/not-audio_url]

Duration: 20:39
In this episode of Scaling Postgres, we discuss scaling for high volume, why workflows should be Postgres rows, a planner gotcha and ways to resolve planner issues. To get the show notes as well as get notified of new ep…
Top Ten Postgres Dos & Don'ts | Scaling Postgres 363 [not-audio_url] [/not-audio_url]

Duration: 13:32
In this episode of Scaling Postgres, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning columns to reduce padding and how to handle disaster recovery. To get the s…
Optimizing For Time-Series Data | Scaling Postgres 362 [not-audio_url] [/not-audio_url]

Duration: 12:22
In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data columns. To get the show notes as well as get not…
A Roadmap To Scaling Postgres | Scaling Postgres 361 [not-audio_url] [/not-audio_url]

Duration: 17:28
In this episode of Scaling Postgres, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, performance cliffs and efficient use of foreign keys. To get the show…
Handle One Million Connections? | Scaling Postgres 360 [not-audio_url] [/not-audio_url]

Duration: 16:17
In this episode of Scaling Postgres, we discuss how a new tool pgDog might allow one million client connections to Postgres, novel use cases for pgvector other than semantic search, don't expose port 5432 and Postgres on…