Scaling Postgres
Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.
Episodes
In this episode of Scaling Postgres, we discuss a 100K events per second queue built on Postgres, how an MCP can leak your database, MultiXact ID and space overrun and struggles starting Postgres.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/376-100k-events-per-second-queue/
In this episode of Scaling Postgres, we discuss new benchmarks as a result of the Planetscale Postgres announcement, various platform improvements and a deep dive into Multigres.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/375-all-the-benchmarks/
Want to learn more about Postgres performance? Join my FREE training called ...
In this episode of Scaling Postgres, we discuss how Jira migrated millions of databases, when sigterm does nothing, should you ditch vector search and mastering replication slots.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/374-migrating-millions-of-databases/
Want to learn more about Postgres performance? Join my FREE tr...
In this episode of Scaling Postgres, we discuss the release of Planetscale Postgres and the advantages for bare metal, how often queries are optimal, avoiding UUIDv4 and the summer of upgrade report.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/373-planetscale-postgres/
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 AWS RDS.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/372-the-future-of-postgres-architecture/
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 as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/371-are-you-hurting-your-performance/
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 as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/370-new-scale-out-options/
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 as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/369-move-off-of-rds/
Want to learn more about Postgres performance? Join my FREE ...
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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/368-4-times-faster-uuid-primary-keys/
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 notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/367-how-often-does-that-query-run/
Want to learn more about Postgres performance? Join my FREE training...
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 issue.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/366-20k-faster-order-by-limit/
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 episodes, visit:
https://www.scalingpostgres.com/episodes/365-here-comes-async-io/
Want to learn more about Postgres performance? Join my FREE training called Postgres P...
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 episodes, visit:
https://www.scalingpostgres.com/episodes/364-scaling-for-high-volume/
Want to learn more about Postgres performance? Join my FREE training called Postgres ...
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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/363-top-ten-postgres-dos-and-donts/
In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data columns.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/362-optimizing-for-time-series-data/
Want to learn more about Postgres performance? Join my FREE tr...
In this episode of Scaling Postgres, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, performance cliffs and efficient use of foreign keys.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/361-roadmap-to-scaling-postgres/
In this episode of Scaling Postgres, we discuss how a new tool pgDog might allow one million client connections to Postgres, novel use cases for pgvector other than semantic search, don't expose port 5432 and Postgres on Kubernetes.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/360-handle-one-million-connections/
In this episode of Scaling Postgres, we talk about indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, processing 1 trillion rows in Citus and partitions for deletion use cases.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/359-trillions-of-rows-and-metrics/
In this episode of Scaling Postgres, I discuss my experience attending Postgres Conference 2025 and cover some of the highlights of the conference. Interestingly, at least from my perspective, the most well attended talks seemed to cover pg_vector, analytics involving duckdb and partitioning.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgre...
In this episode of Scaling Postgres, we discuss best practices, caching monitoring statistics, a new vector extension called VectorChord and the importance of monitoring wait events.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/357-postgres-best-practices/
Want to learn more about Postgres performance? Join my FREE trainin...
Popular Podcasts
Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations. Special Summer Offer: Exclusively on Apple Podcasts, try our Dateline Premium subscription completely free for one month! With Dateline Premium, you get every episode ad-free plus exclusive bonus content.
The World's Most Dangerous Morning Show, The Breakfast Club, With DJ Envy, Jess Hilarious, And Charlamagne Tha God!
Does hearing about a true crime case always leave you scouring the internet for the truth behind the story? Dive into your next mystery with Crime Junkie. Every Monday, join your host Ashley Flowers as she unravels all the details of infamous and underreported true crime cases with her best friend Brit Prawat. From cold cases to missing persons and heroes in our community who seek justice, Crime Junkie is your destination for theories and stories you won’t hear anywhere else. Whether you're a seasoned true crime enthusiast or new to the genre, you'll find yourself on the edge of your seat awaiting a new episode every Monday. If you can never get enough true crime... Congratulations, you’ve found your people. Follow to join a community of Crime Junkies! Crime Junkie is presented by audiochuck Media Company.
The Clay Travis and Buck Sexton Show. Clay Travis and Buck Sexton tackle the biggest stories in news, politics and current events with intelligence and humor. From the border crisis, to the madness of cancel culture and far-left missteps, Clay and Buck guide listeners through the latest headlines and hot topics with fun and entertaining conversations and opinions.
The Megyn Kelly Show is your home for open, honest and provocative conversations with the most interesting and important political, legal and cultural figures today. No BS. No agenda. And no fear.