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 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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/397-vacuum-is-lying-to-you/
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 episodes, visit:
https://www.scalingpostgres.com/episodes/396-600-times-faster-analytics/
Want to learn more about Postgres performance? Join my FREE training called Pos...
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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/395-16-times-faster-join-plans/
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 get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/394-five-times-faster-aggregates/
Want to learn more about Postgres performance? Join my FR...
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 as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/393-job-security/
Want to learn more about Postgres performance? Join my FREE training ca...
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/
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 notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/391-table-lock-explosion/
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 episodes, visit:
https://www.scalingpostgres.com/episodes/390-1.2-million-messages-per-second/
Want to learn more about Postgres performance? Join my FREE training called Post...
In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight locks and a backup public service announcement.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/389-heavy-reader-or-writer/
In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a faster software & hardware environment cause performance problems?
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/388-nvme-wins/
In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budget, how to build a parquet file archive solution and we discuss the completion of the summer of upgrades.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/387-boosting-planning-performance/
In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and how recent Ubuntu OS patches cause a Postgres restart.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/386-postgres-18-the-deep-cuts/
In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from statements, parallel apply, adding not null as not valid and more!
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/385-postgres-18-released/
In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a zero downtime upgrade.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/384-preparing-for-postgres-18/
Want to learn more about Postgres performance? Join my FREE training called Postgres ...
In this episode of Scaling Postgres, we discuss free availability of an OrioleDB patent, pgEdge going open source, pg_duckdb hitting 1.0 and methods resolve to slow order by limit queries.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/383-orioledb-more-free/
Want to learn more about Postgres performance? Join my FREE traini...
In this episode of Scaling Postgres, we discuss using a LLM as an agent, the importance of partitioned table statistics, PG 18 RC1, primary keys in sharded databases and a blue/green rollback.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/382-db-llm-agents/
Want to learn more about Postgres performance? Join my FREE trainin...
In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS Proxy oddities.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/381-documentdb-movement/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance D...
In this episode of Scaling Postgres, we discuss enhancements to Oriole DB, new Postgres releases, a logging guide and application framework frustrations.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/380-storage-engine-progress/
Want to learn more about Postgres performance? Join my FREE training called Postgres Performance...
In this episode of Scaling Postgres, we discuss when you should reindex, how to handle case insensitive data, how to index jsonb and the top recommendations when doing performance optimizations.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/379-unconventional-advice/
Want to learn more about Postgres performance? Join my FR...
In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify, and a logical replication slot deep dive.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/378-native-column-store/
Want to learn more about Postgres performance? Join my FREE t...
Popular Podcasts
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.
)
My Favorite Murder is a true crime comedy podcast hosted by Karen Kilgariff and Georgia Hardstark. Each week, Karen and Georgia share compelling true crimes and hometown stories from friends and listeners. Since MFM launched in January of 2016, Karen and Georgia have shared their lifelong interest in true crime and have covered stories of infamous serial killers like the Night Stalker, mysterious cold cases, captivating cults, incredible survivor stories and important events from history like the Tulsa race massacre of 1921. My Favorite Murder is part of the Exactly Right podcast network that provides a platform for bold, creative voices to bring to life provocative, entertaining and relatable stories for audiences everywhere. The Exactly Right roster of podcasts covers a variety of topics including historic true crime, comedic interviews and news, science, pop culture and more. Podcasts on the network include Buried Bones with Kate Winkler Dawson and Paul Holes, That's Messed Up: An SVU Podcast, This Podcast Will Kill You, Bananas and more.
Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations. Follow now to get the latest episodes of Dateline NBC completely free, or subscribe to Dateline Premium for ad-free listening and exclusive bonus content: DatelinePremium.com
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.