100 Times Faster By Skipping! | Scaling Postgres 392

100 Times Faster By Skipping! | Scaling Postgres 392

Author: Creston Jamison November 17, 2025 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 notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/392-100-times-faster-by-skipping/ 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 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…
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…
1.2 Million Messages Per Second | Scaling Postgres 390 [not-audio_url] [/not-audio_url]

Duration: 17:32
In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested partitioning. To get the show notes as well as get notified of new episo…