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
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…
Trillions of Rows & Metrics | Scaling Postgres 359 [not-audio_url] [/not-audio_url]

Duration: 18:27
In this episode of Scaling Postgres, we talk about indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, processing 1 trillion rows in Citus and partitions for deletion use cases. T…
Postgres Conference 2025 | Scaling Postgres 358 [not-audio_url] [/not-audio_url]

Duration: 23:37
In this episode of Scaling Postgres, I discuss my experience attending Postgres Conference 2025 and cover some of the highlights of the conference. Interestingly, at least from my perspective, the most well attended talk…
Postgres Best Practices? | Scaling Postgres 357 [not-audio_url] [/not-audio_url]

Duration: 9:58
In this episode of Scaling Postgres, we discuss best practices, caching monitoring statistics, a new vector extension called VectorChord and the importance of monitoring wait events. To get the show notes as well as get…
Is the Future Immutable? | Scaling Postgres 356 [not-audio_url] [/not-audio_url]

Duration: 15:21
In this episode of Scaling Postgres, we discuss immutability and Postgres, the upcoming Postgres Conference in Orlando, extended statistics and usage of default partitions. To get the show notes as well as get notified o…
Top Ten Analytics with pg_mooncake | Scaling Postgres 355 [not-audio_url] [/not-audio_url]

Duration: 15:59
In this episode of Scaling Postgres, we discuss how Postgres & pg_mooncake achieves top ten Clickbench results, a comparison of Oracle and Postgres transactions, sharding to scale and connection counts. To get the show n…
Postgres & The US Treasury Attack | Scaling Postgres 354 [not-audio_url] [/not-audio_url]

Duration: 15:43
In this episode of Scaling Postgres, we discuss the role of Postgres in the US Treasury online attack, new releases of Postgres, optimizing application of streaming changes and a query that filled a databases disks. To g…
OLTP To Parquet For Analytics | Scaling Postgres 353 [not-audio_url] [/not-audio_url]

Duration: 15:59
In this episode of Scaling Postgres, we discuss how data can flow from your OLTP to parquet files for analytics, parallel queries, view inlining and partitioning advice. To get the show notes as well as get notified of n…

«12345678910»