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
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…
Faster Writes With ZFS? | Scaling Postgres 342 [not-audio_url] [/not-audio_url]

Duration: 13:19
In this episode of Scaling Postgres, we discuss the read and write performance of Postgres on ZFS, handling URL text identifiers in the database, denormalization and a new pgvector release. To get the show notes as well…
The Future of Postgres Upgrades | Scaling Postgres 341 [not-audio_url] [/not-audio_url]

Duration: 14:15
In this episode of Scaling Postgres, we discuss the future of Postgres upgrades, the usefulness of pg_dump, partitioning with minimal downtime and limitless Aurora. To get the show notes as well as get notified of new ep…
Do You Need A Vectorizer? | Scaling Postgres 340 [not-audio_url] [/not-audio_url]

Duration: 16:39
In this episode of Scaling Postgres, we discuss whether you need a vectorizer, different ways to bin or bucket timestamps, addressing a bad plan and advanced psql. To get the show notes as well as get notified of new epi…