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
Scaling Postgres
Technology
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

Official website RSS
Scaling Postgres
Podcast Episodes
Sometimes It Is Slow? | Scaling Postgres 332 [not-audio_url] [/not-audio_url]

Duration: 15:10
In this episode of Scaling Postgres, we discuss what can happen when queries get slow, backup best practices, Postgres emergencies and the state of Postgres survey. To get the show notes as well as get notified of new ep…
Is pg_dump A Backup Tool? | Scaling Postgres 331 [not-audio_url] [/not-audio_url]

Duration: 17:31
In this episode of Scaling Postgres, we discuss whether pg_dump is a backup tool, the pgMonitor extension, Postgres malware, and application uses for the merge command. To get the show notes as well as get notified of ne…
Splicing Elephant & Duck DNA | Scaling Postgres 330 [not-audio_url] [/not-audio_url]

Duration: 14:58
In this episode of Scaling Postgres, we discuss the merging of Postgres and DuckDB via the pg_duckdb extension, how this can help the analytics story for Postgres, some ways to improve PG analytics and building a search…
PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329 [not-audio_url] [/not-audio_url]

Duration: 19:01
In this episode of Scaling Postgres, we discuss PGlite, an embeddable Postgres, postgres.new which adds AI features, new Postgres releases and the performance of synchronous replication. To get the show notes as well as…
Implement Get Or Create | Scaling Postgres 328 [not-audio_url] [/not-audio_url]

Duration: 16:10
In this episode of Scaling Postgres, we discuss different get or create implementations, a new pgBouncer version, alter default privileges, and six degrees of separation with Postgres. To get the show notes as well as ge…
Postgres Graph Queries | Scaling Postgres 327 [not-audio_url] [/not-audio_url]

Duration: 16:30
In this episode of Scaling Postgres, we discuss using Postgres for graph queries, the fastest way to copy data from one table to another, dealing with linux memory overcommit and compression. To get the show notes as wel…
Faster Index Creation | Scaling Postgres 326 [not-audio_url] [/not-audio_url]

Duration: 20:28
In this episode of Scaling Postgres, we talk about speeding up index creation, extensions to track wait events, a row pattern recognition feature and savepoints. To get the show notes as well as get notified of new episo…
Faster Paging? | Scaling Postgres 325 [not-audio_url] [/not-audio_url]

Duration: 20:07
In this episode of Scaling Postgres, we discuss more ways to keep the superior performance of keyset pagination, how to implement UUIDv7 in SQL functions, how expensive extended statistics are and the benefits of range c…
Four Million TPS | Scaling Postgres 324 [not-audio_url] [/not-audio_url]

Duration: 16:29
In this episode of Scaling Postgres, we discuss experiments to achieve four million transaction per second, the importance of extended statistics, parallelism in Postgres and an introduction to window functions. To get t…
PgBouncer Breaking Change | Scaling Postgres 323 [not-audio_url] [/not-audio_url]

Duration: 23:47
In this episode of Scaling Postgres, we discuss a breaking change in the new version of PgBouncer, PostgreSQL 17 Beta 2 is released, examination of the new built-in collation provider in PG 17 and Notion's data lake. To…

«1...5678910»