Half as Fast on Linux 7  | Scaling Postgres 412

Half as Fast on Linux 7 | Scaling Postgres 412

Author: Creston Jamison April 13, 2026 Duration: 15:31
In this episode of Scaling Postgres, we discuss how Postgres may be half as fast on the new Linux 7 kernel, PostgresBench, what is missing in Postgres and WAL to distribute data. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/412-half-as-fast-on-linux-7/ 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
Millions of QPS | Scaling Postgres 402 [not-audio_url] [/not-audio_url]

Duration: 18:25
In this episode of Scaling Postgres, we discuss how OpenAI's ChatGPT handles millions of queries per second, an update on PgDog, Clickhouse offers OLTP hosted Postgres and partition table source of truth. To get the show…
One Billion Vectors On Postgres | Scaling Postgres 401 [not-audio_url] [/not-audio_url]

Duration: 22:06
In this episode of Scaling Postgres, we discuss searching one billion vectors on Postgres, how to bypass a vector index search, unconventional optimizations and a 40x boost to listen/notify performance. To get the show n…
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…