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
The Future of Postgres Architecture | Scaling Postgres 372 [not-audio_url] [/not-audio_url]

Duration: 19:26
In this episode of Scaling Postgres, we discuss some possible futures for Postgres architectures, choosing a multi-tenancy model, vectors in the new SQL standard and one way to perform a blue-green deployment rollback in…
Are You Hurting Your Performance? | Scaling Postgres 371 [not-audio_url] [/not-audio_url]

Duration: 21:08
In this episode of Scaling Postgres, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads and some downsides of different upgrade methods. To get the show notes as well a…
New Scale Out Options | Scaling Postgres 370 [not-audio_url] [/not-audio_url]

Duration: 14:51
In this episode of Scaling Postgres, we discuss the start of Multigres which is a Vitess for Postgres, pgactive going open source, getting started with logical replication and a summer of upgrades. To get the show notes…
Move Off Of RDS? | Scaling Postgres 369 [not-audio_url] [/not-audio_url]

Duration: 18:01
In this episode of Scaling Postgres, we discuss why and how you could move off of AWS RDS, Snowflake acquires Crunchy Data, reducing your SQL queries and a novel way to migrate to partition tables. To get the show notes…
4 Times Faster UUID Primary Keys | Scaling Postgres 368 [not-audio_url] [/not-audio_url]

Duration: 19:10
In this episode of Scaling Postgres, we discuss the benefits of using time-based UUIDv7 vs UUIDv4 for primary keys, how OpenAI uses Postgres, handling locks and methods to migrate to partition tables with low downtime. T…
How Often Does That Query Run? | Scaling Postgres 367 [not-audio_url] [/not-audio_url]

Duration: 13:10
In this episode of Scaling Postgres, we discuss a Postgres VS code extension, service definition files, undead tuples and the benefits of finding out how often a query is run. To get the show notes as well as get notifie…
20,000 Times Faster Order By Limit | Scaling Postgres 366 [not-audio_url] [/not-audio_url]

Duration: 14:46
In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times faster query by fixing an order by limit iss…
Here Comes Async I/O! | Scaling Postgres 365 [not-audio_url] [/not-audio_url]

Duration: 20:01
In this episode of Scaling Postgres, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovative ways to optimize queries. To get the show notes as well as get notified of new…
Scaling For High Volume | Scaling Postgres 364 [not-audio_url] [/not-audio_url]

Duration: 20:39
In this episode of Scaling Postgres, we discuss scaling for high volume, why workflows should be Postgres rows, a planner gotcha and ways to resolve planner issues. To get the show notes as well as get notified of new ep…
Top Ten Postgres Dos & Don'ts | Scaling Postgres 363 [not-audio_url] [/not-audio_url]

Duration: 13:32
In this episode of Scaling Postgres, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning columns to reduce padding and how to handle disaster recovery. To get the s…