The Cost of Arrays | Scaling Postgres 400

The Cost of Arrays | Scaling Postgres 400

Author: Creston Jamison January 19, 2026 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 notified of new episodes, visit: https://www.scalingpostgres.com/episodes/400-the-cost-of-arrays/ 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
Postgres 19 Beta 1 Released | Scaling Postgres 420 [not-audio_url] [/not-audio_url]

Duration: 18:57
In this episode of Scaling Postgres, we discuss the release of Postgres 19 Beta 1, optimizing autovacuum, the release of Multigres 0.1 Alpha 1, and handling graph queries in Postgres. To get the show notes as well as get…
The Dynamic Duo? | Scaling Postgres 419 [not-audio_url] [/not-audio_url]

Duration: 15:39
In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations. To get the show notes as well as get notified of…
Multigres Architecture | Scaling Postgres 418 [not-audio_url] [/not-audio_url]

Duration: 16:51
In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations. To get the show notes as well as get notified of…
11 Security Issues  | Scaling Postgres 417 [not-audio_url] [/not-audio_url]

Duration: 19:56
In this episode of Scaling Postgres, we discuss new Postgres releases that patch eleven security issues, a new pgbouncer release patching four security issues, making JSON queryable, and issues with views. To get the sho…
Zero Bloat Postgres Queue  | Scaling Postgres 416 [not-audio_url] [/not-audio_url]

Duration: 15:09
In this episode of Scaling Postgres, we discuss a new zero bloat Postgres queue called PgQue, maybe pgBackRest isn't dead, multixact members at 64 bits and using session variables. To get the show notes as well as get no…
pgBackRest Is Dead?  | Scaling Postgres 415 [not-audio_url] [/not-audio_url]

Duration: 16:26
In this episode of Scaling Postgres, we discuss the notice of obsolescence for pgBackRest, the open source environment in general, queries to monitor autovacuum and pg_wait_tracer. To get the show notes as well as get no…
Repack Concurrently  | Scaling Postgres 414 [not-audio_url] [/not-audio_url]

Duration: 19:55
In this episode of Scaling Postgres, we discuss repack concurrently coming to PG 19, how to design your schema, all about hints and enforcing constraints across partitions. To get the show notes as well as get notified o…
Shard With One Command  | Scaling Postgres 413 [not-audio_url] [/not-audio_url]

Duration: 19:52
In this episode of Scaling Postgres, we discuss sharding your database with one command, more information about the Linux 7 Postgres performance regression, Xata going open source, and checkpoints and WAL storms. To get…
Half as Fast on Linux 7  | Scaling Postgres 412 [not-audio_url] [/not-audio_url]

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 noti…
Absorbing Load | Scaling Postgres 411 [not-audio_url] [/not-audio_url]

Duration: 19:55
In this episode of Scaling Postgres, we discuss techniques to absorb excessive query load, BM25 text search via pg_textsearch, good & bad CTEs and plan_cache_mode. To get the show notes as well as get notified of new epi…