Out of Cycle Releases | Scaling Postgres 405

Out of Cycle Releases | Scaling Postgres 405

Author: Creston Jamison February 23, 2026 Duration: 16:59
In this episode of Scaling Postgres, we discuss an out of cycle Postgres release, a Supabase downtime incident, optimizing top K queries and how to maintain reading efficiency. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/405-out-of-cycle-releases/ 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
You Can Always Optimize More | Scaling Postgres 352 [not-audio_url] [/not-audio_url]

Duration: 14:32
In this episode of Scaling Postgres, we discuss how you can always optimize more, avoiding deadlocks, casting & indexes and pg_hint_plan best practices. To get the show notes as well as get notified of new episodes, visi…
Features To Avoid? | Scaling Postgres 351 [not-audio_url] [/not-audio_url]

Duration: 16:55
In this episode of Scaling Postgres, we talk about some features you may want to avoid like commit_delay, index_cleanup off, & logon triggers, a way to detect a table rewrite and a zero downtime upgrade. To get the show…
Seven Years of Scaling Postgres | Scaling Postgres 350 [not-audio_url] [/not-audio_url]

Duration: 19:09
In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group by statistics. To get the show notes as well as get n…
The Dangers of Temporary Tables | Scaling Postgres 349 [not-audio_url] [/not-audio_url]

Duration: 15:24
In this episode of Scaling Postgres, we discuss the dangers of temporary tables, better transparent data encryption, pig the extension wizard, and table level lock considerations. To get the show notes as well as get not…
The Future Is Containers? | Scaling Postgres 348 [not-audio_url] [/not-audio_url]

Duration: 12:28
In this episode of Scaling Postgres, we discuss whether the future of containers and Postgres, UUIDv7 commit, and a pg_duckdb interview. To get the show notes as well as get notified of new episodes, visit: https://www.s…
Easy Incremental Data Processing? | Scaling Postgres 347 [not-audio_url] [/not-audio_url]

Duration: 14:47
In this episode of Scaling Postgres, we discuss the new pg_incremental extension for processing data pipelines, a set of Postgres monitoring queries, handling alter table retries and large object dump performance. To get…
Things I Don't Do In Postgres | Scaling Postgres 346 [not-audio_url] [/not-audio_url]

Duration: 15:47
In this episode of Scaling Postgres, we discuss things I do not do such as use default partitions, play column Tetris, ELT using special data types or create 7+ millions tables in a database. To get the show notes as wel…
Over 5X Faster Postgres? | Scaling Postgres 345 [not-audio_url] [/not-audio_url]

Duration: 17:02
In this episode of Scaling Postgres, we discuss OrioleDB getting Postgres over 5 times faster, historical OLAP performance, efficient queries and whether you should us track_planning. To get the show notes as well as get…
Performance & Hard Things | Scaling Postgres 344 [not-audio_url] [/not-audio_url]

Duration: 17:38
In this episode of Scaling Postgres, we discuss new releases, collation speed, ZFS performance, insert benchmarking and pglz vs. lz4 performance. To get the show notes as well as get notified of new episodes, visit: http…
Postgres Release Warning! | Scaling Postgres 343 [not-audio_url] [/not-audio_url]

Duration: 18:50
In this episode of Scaling Postgres, we discuss new Postgres releases and an out-of-band release to address issues, increasing insert performance by 2X, pg_search benchmarks and fast OpenStreetMap loading. To get the sho…