Open Source Eating The World | Scaling Postgres 408

Open Source Eating The World | Scaling Postgres 408

Author: Creston Jamison March 16, 2026 Duration: 17:05
In this episode of Scaling Postgres, we discuss how open source is eating the world, mitigating plan flips, migrating from Heroku to RDS, and how work_mem is a trap. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/408-open-source-eating-the-world/ 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
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…
Postgres Goes Parquet | Scaling Postgres 339 [not-audio_url] [/not-audio_url]

Duration: 11:32
In this episode of Scaling Postgres, we discuss pg_parquet allowing Postgres to read and write parquet files, other useful extensions, open source bounties, and Postgres gotchas. To get the show notes as well as get noti…
JSON Goodies In Postgres 17 | Scaling Postgres 338 [not-audio_url] [/not-audio_url]

Duration: 17:03
In this episode of Scaling Postgres, we discuss the JSON goodies in Postgres 17, trigger recursion, pg_dump as backup and pg_timeseries columnar performance. To get the show notes as well as get notified of new episodes,…
77 Times Faster In Postgres 17 | Scaling Postgres 337 [not-audio_url] [/not-audio_url]

Duration: 14:19
In this episode of Scaling Postgres, we discuss how one query runs 77 times faster in Postgres 17, a detailed Postgres 17 performance webinar, using logical replication fail over slots and a discussion on Patroni. To get…
More Postgres 17 Highlights | Scaling Postgres 336 [not-audio_url] [/not-audio_url]

Duration: 12:54
In this episode of Scaling Postgres, we discuss more about the features released with Postgres 17, an example of performance improvements, things to watch out for, and the start of Postgres 18. To get the show notes as w…
Postgres 17 Released! | Scaling Postgres 335 [not-audio_url] [/not-audio_url]

Duration: 18:32
In this episode of Scaling Postgres, we discuss the release of Postgres 17, b-tree performance gains, logical replication enhancements and different levels of performance tuning. To get the show notes as well as get noti…
Optimizing For Analytics | Scaling Postgres 334 [not-audio_url] [/not-audio_url]

Duration: 21:55
In this episode of Scaling Postgres, we discuss how to optimize your database for analytics, how to speed up counts, improvements to TimescaleDB and why you should stop using serial. To get the show notes as well as get…
When Select Writes! | Scaling Postgres 333 [not-audio_url] [/not-audio_url]

Duration: 13:38
In this episode of Scaling Postgres, we discuss when select can write, Postgres RC1 is released, Tetris in SQL and copy, swap, drop. To get the show notes as well as get notified of new episodes, visit: https://www.scali…