Scaling Postgres

Scaling Postgres

Author: Creston Jamison Language: English Episodes: 100
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.
Episodes
The Cost of Arrays | Scaling Postgres 400 [not-audio_url] [/not-audio_url]

Duration: 17:42
In this episode of Scaling Postgres, we discuss the cost of arrays, dealing with integer overflow, idle sessions causing transaction wraparound and AI or LLM index recommendations. To get the show notes as well as get no…
Index Overhead? | Scaling Postgres 399 [not-audio_url] [/not-audio_url]

Duration: 19:18
In this episode of Scaling Postgres, we discuss the overhead of indexes, a Postgres year in review, an intro to row locking and table renaming issues. To get the show notes as well as get notified of new episodes, visit:…
Latency Killing Performance? | Scaling Postgres 398 [not-audio_url] [/not-audio_url]

Duration: 19:42
In this episode of Scaling Postgres, we examine how latency impacts performance, naughty queries, bm25 indexes and how to quickly create database clones. To get the show notes as well as get notified of new episodes, vis…
Vacuum Is Lying To You? | Scaling Postgres 397 [not-audio_url] [/not-audio_url]

Duration: 16:48
In this episode of Scaling Postgres, we discuss if vacuum is lying to you with regard to index cleanup, an agentic toolkit with MCP server, indexes getting corrupted after an upgrade and $50 Planetscale Metal. To get the…
600 Times Faster Analytics | Scaling Postgres 396 [not-audio_url] [/not-audio_url]

Duration: 18:48
In this episode of Scaling Postgres, we discuss using Postgres queries in ClickHouse, faster faceted search, max_connections & migrations and different scan types. To get the show notes as well as get notified of new epi…
16 Times Faster Join Plans | Scaling Postgres 395 [not-audio_url] [/not-audio_url]

Duration: 16:11
In this episode of Scaling Postgres, we discuss a patch that can plan joins 16 times faster, the best way to record text values, extensions via image volumes with CloudNativePG and using pg_partman vs rolling your own. T…
5 Times Faster Aggregates | Scaling Postgres 394 [not-audio_url] [/not-audio_url]

Duration: 16:28
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should hard your datbase. To get the show notes as well as…
Job Security? | Scaling Postgres 393 [not-audio_url] [/not-audio_url]

Duration: 14:41
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should shard your database. To get the show notes as well…
100 Times Faster By Skipping! | Scaling Postgres 392 [not-audio_url] [/not-audio_url]

Duration: 15:52
In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more details about my upcoming course discount. To get the show not…
Table Lock Explosion! | Scaling Postgres 391 [not-audio_url] [/not-audio_url]

Duration: 19:15
In this episode of Scaling Postgres, we discuss the issues of partition locking during planning, the problem of too much memory, the importance of a txvector column and an upcoming sale on my course. To get the show note…