A weekly podcast about all things PostgreSQL
…
continue reading
Postgres Podcasts
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.
…
continue reading
Talking Postgres is a podcast for developers who love Postgres. Guests join Claire Giordano each month to discuss the human side of PostgreSQL, databases, and open source. With amazing guests such as Boriss Mejías, Melanie Plageman, Tom Lane, Simon Willison, Robert Haas, and Andres Freund, Talking Postgres is guaranteed to get you thinking. Recorded live on Discord by the Postgres team at Microsoft, you can subscribe to our calendar to join us live on the parallel text chat (which is quite f ...
…
continue reading
All about extensions, extension creators, and people doing cool things with Postgres. New episodes every week.
…
continue reading
Join database educator Aaron Francis as he gets schooled by database professionals.
…
continue reading
Hanselminutes is Fresh Air for Developers. A weekly commute-time podcast that promotes fresh technology and fresh voices. Talk and Tech for Developers, Life-long Learners, and Technologists.
…
continue reading
Welcome to the Backend Engineering Show podcast with your host Hussein Nasser. If you like software engineering you’ve come to the right place. I discuss all sorts of software engineering technologies and news with specific focus on the backend. All opinions are my own. Most of my content in the podcast is an audio version of videos I post on my youtube channel here http://www.youtube.com/c/HusseinNasser-software-engineering Buy me a coffee https://www.buymeacoffee.com/hnasr 🧑🏫 Courses I Te ...
…
continue reading
A weekly podcast about web design and development with a little zest from Amy Dutton and Brad Garropy
…
continue reading
The Data Engineering Show is a podcast for data engineering and BI practitioners to go beyond theory. Learn from the biggest influencers in tech about their practical day-to-day data challenges and solutions in a casual and fun setting. SEASON 1 DATA BROS Eldad and Boaz Farkash shared the same stuffed toys growing up as well as a big passion for data. After founding Sisense and building it to become a high-growth analytics unicorn, they moved on to their next venture, Firebolt, a leading hig ...
…
continue reading
This week's JavaScript news, in 4 min or less.
…
continue reading
Hi! We are Chris & Creston the Rubber Duck Devs! Welcome to the Rubber Duck Dev Show! The weekly live talk show all about software development. We'll be talking about: - Different Languages (Ruby, Python, Javascript, etc.) - Project management (tools and communication techniques) - Databases (SQL, NoSQL, NewSQL, Redis, etc.) - Servers (ensuring security and high availability) - Guest interviews And much more! Each week, we'll pick a topic and do a deep dive. We'll explore all the facts, tren ...
…
continue reading
The Coder Career Podcast is a show that helps aspiring software developers navigate the journey to a fulfilling and successful career in tech. Each episode features interviews by career changing software engineer Cameron Blackwood with industry professionals, career advice, and insights on the latest trends and technologies in the field. Whether you're just starting out in coding or looking to take your career to the next level, The Coder Career Podcast has something for you. Tune in to lear ...
…
continue reading
1
16 Times Faster Join Plans | Scaling Postgres 395
16:11
16:11
Play later
Play later
Lists
Like
Liked
16:11In 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-…
…
continue reading
Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!) Here are some links to things they mentioned: max_connections https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-MAX-CONNECTIONS Tweet about deployments vs connections issue https://…
…
continue reading
In this episode, Aaron talks with Dennis Magda, author of Just Use Postgres!, about the wide world of modern Postgres, from JSON and full-text search to generative AI, time-series storage, and even message queues. They explore when Postgres should be your go-to tool, when it shouldn’t, and why understanding its breadth helps developers build better…
…
continue reading
1
Why Postgres? and why now? with Claire Giordano
36:11
36:11
Play later
Play later
Lists
Like
Liked
36:11Postgres has quietly become the world’s favorite database...running startups, governments, and global clouds alike. Scott talks with Claire Giordano, long-time Postgres advocate and technologist, about the database’s unlikely rise from academic roots to modern dominance. They explore its design philosophy, the open-source community that fuels it, a…
…
continue reading
1
Scaling DuckDB in the cloud with MotherDuck CEO Jordan Tigani
1:05:15
1:05:15
Play later
Play later
Lists
Like
Liked
1:05:15In this episode of Database School, Aaron Francis sits down with Jordan Tigani, co-founder and CEO of MotherDuck, to break down what DuckDB is, how MotherDuck hosts it in the cloud, and why analytics workloads are shifting toward embedded databases. They dig into Duck Lake, pricing models, scaling strategies, and what it really takes to build a mod…
…
continue reading
1
Human Agency in a Digital World with Marcus Fontoura
34:51
34:51
Play later
Play later
Lists
Like
Liked
34:51Marcus Fontoura has led engineering teams at IBM, Yahoo, Google, and Microsoft...building the very systems that power our digital lives. Now, as the author of Human Agency in a Digital World, he’s asking a more profound question: how do we stay in charge of the technology we create? Scott and Marcus explore what it means to move from being passenge…
…
continue reading
1
Daniel Temkin and the Beauty of Esoteric Languages
35:12
35:12
Play later
Play later
Lists
Like
Liked
35:12What happens when code stops being useful and starts being art? Scott talks with artist and programmer Daniel Temkin about his new book Forty-Four Esolangs, a deep dive into the world of esoteric programming languages...systems designed not to ship software, but to provoke thought. They explore how absurdity, constraint, and humor reveal something …
…
continue reading
1
5 Times Faster Aggregates | Scaling Postgres 394
16:28
16:28
Play later
Play later
Lists
Like
Liked
16:28In 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 mor…
…
continue reading
1
The Digital Runway: IT at the Philadelphia Airport with Camille Tomlin
32:15
32:15
Play later
Play later
Lists
Like
Liked
32:15Scott sits down with Camille Tomlin, Head of IT at Philadelphia International Airport, to explore the intersection of aviation, technology, and leadership. They discuss how airports are transforming digitally — with IoT, data analytics, and smart infrastructure — and how Camille leads a team that bridges city government, airlines, and millions of p…
…
continue reading
Page faults occurs when the process tries to access a memory that isn’t backed by a physical page kernel raises a fault which loads a page. It happens on first access, stack expansion, COW, swap and much more. However it comes with a cost. In this episode of the backend engineering show I dissect the need and the cost page faults in the kernel. 0:0…
…
continue reading
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 Postgr…
…
continue reading
Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18. Here are some links to things they mentioned: EXPLAIN (official docs) https://www.postgresql.org/docs/current/sql-explain.html Using EXPLAIN (official docs) https://www.postgresql.org/docs/current/using-explain.html EXPLAIN glossary (pgMustard site) https://www.pgmu…
…
continue reading
1
Strictly typed SQL with Contra CTO, Gajus Kuizinas
59:50
59:50
Play later
Play later
Lists
Like
Liked
59:50In this episode, Gajus Kuizinas, co-founder and CTO of Contra, joins Aaron to talk about building the engineering world you want to live in, from strict runtime-validated SQL with Slonik to creating high-ownership engineering cultures. They dive into developer experience, runtime assertions, SafeQL, and even “Loom-driven development,” a powerful re…
…
continue reading
1
C++ is Still Here, Still Powerful with Gabriel Dos Reis
35:50
35:50
Play later
Play later
Lists
Like
Liked
35:50In a world of Rust, Go, and Python, why does C++ still matter? Dr. Gabriel Dos Reis joins Scott to explain how C++ continues to shape everything from GPUs and browsers to AI infrastructure. They talk about performance, predictability, and the art of balancing power with safety...and how the language’s constant evolution keeps it relevant four decad…
…
continue reading
1
60 Billion Predictions Daily: Inside Credit Karma’s Agentic Data Layer with Maddie Daianu
19:55
19:55
Play later
Play later
Lists
Like
Liked
19:55What does MLOps look like when you are deploying 22,000 models a month? Maddie Daianu, Head of Data and AI at Intuit Credit Karma, joins the Data Bros to pull back the curtain on one of the most high-volume data environments in FinTech. With a 100-person team serving 140 million members, standard data practices break down. Maddie shares how her tea…
…
continue reading
1
100 Times Faster By Skipping! | Scaling Postgres 392
15:52
15:52
Play later
Play later
Lists
Like
Liked
15:52In 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/ Want…
…
continue reading
Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica. Here are some links to things they mentioned: Ultra-fast replica creation with pgBackRest (blog post by Maxim Boguk and Nik) https://postgres.ai/blog/20251105-postgres-marathon-2-012-ultra-fast-replica-creation-pgbackrest C…
…
continue reading
1
Building serverless vector search with Turbopuffer CEO, Simon Eskildsen
1:06:48
1:06:48
Play later
Play later
Lists
Like
Liked
1:06:48In this episode, Aaron Francis talks with Simon Eskildsen, co-founder and CEO of TurboPuffer, about building a high-performance search engine and database that runs entirely on object storage. They dive deep on Simon's time as an engineer at Shopify, database design trade-offs, and how TurboPuffer powers modern AI workloads like Cursor and Notion. …
…
continue reading
1
Table Lock Explosion! | Scaling Postgres 391
19:15
19:15
Play later
Play later
Lists
Like
Liked
19:15In 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/ Want to learn…
…
continue reading
1
Building a dev experience for Postgres in VS Code with Rob Emanuele
1:18:40
1:18:40
Play later
Play later
Lists
Like
Liked
1:18:40What do guitar busking, geospatial queries, and agentic coding have to do with Postgres? In Episode 33 of Talking Postgres, principal engineer Rob Emanuele at Microsoft shares his winding path from Venice Beach to building a new VS Code extension for PostgreSQL—that works with any Postgres, anywhere. We dig into GitHub Copilot, ask vs. agent mode, …
…
continue reading
1
Building an S3 Competitor with Tigris CEO Ovais Tariq
1:07:27
1:07:27
Play later
Play later
Lists
Like
Liked
1:07:27Aaron talks with Ovais Tariq, co-founder and CEO of Tigris Data and former Uber engineer who helped scale one of the world’s largest distributed systems. They discuss Uber’s hyperscale infrastructure, what it takes to build an S3-compatible object store from scratch, and how distributed storage is evolving for the AI era. Follow Ovais: Twitter: htt…
…
continue reading
1
The Past Still Boots with the Interim Computing Museum's Stephen Jones
40:46
40:46
Play later
Play later
Lists
Like
Liked
40:46Scott talks with Stephen Jones of the new Interim Computing Museum, about the craft of bringing old computers back to life. From wire-wrapped boards to tape drives and terminals, this episode dives into why running the old systems — not just displaying them — matters for understanding how modern computing came to be. Support, Visit, and Donate to t…
…
continue reading
1
1.2 Million Messages Per Second | Scaling Postgres 390
17:32
17:32
Play later
Play later
Lists
Like
Liked
17:32In 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 perfor…
…
continue reading
On October 19 2025 AWS experienced an outage that lasted over a day, 10 days later we finally got the root cause analysis and we know exactly what caused the DNS to fail0:00 Summary 5:30 How did Dynamo lost its DNS?13:41 EC2 Errors 16:16 Network Load Balancer ErrorsRCA here https://aws.amazon.com/message/101925/…
…
continue reading
Nik and Michael discuss the concept of gapless sequences — when you might want one, why sequences in Postgres can have gaps, and an idea or two if you do want them. And one quick clarification: changing the CACHE option in CREATE SEQUENCE can lead to even more gaps, the docs mention it explicitly. Here are some links to things they mentioned: CREAT…
…
continue reading
1
Cheat Codes for Junior Engineers with Kat Excellence
35:22
35:22
Play later
Play later
Lists
Like
Liked
35:22This week Scott talks to Kat who shares her tactical wisdom from her blog Katexcellence.io, where she decodes the early-career engineering experience with clarity and wit. From learning to build without motivation, to balancing depth and velocity, to navigating layoffs and early‑career uncertainty, Kat distills lessons from her own journey through …
…
continue reading
1
Rewriting SQLite from prison with Preston Thorpe
1:18:28
1:18:28
Play later
Play later
Lists
Like
Liked
1:18:28In this episode of Database School, Aaron talks with Preston Thorpe, a senior engineer at Turso who is currently incarcerated, about his incredible journey from prison to rewriting SQLite in Rust. They dive deep into concurrent writes, MVCC, and the challenges of building a new database from scratch while discussing redemption, resilience, and raw …
…
continue reading
1
Heavy Reader or Writer? | Scaling Postgres 389
14:21
14:21
Play later
Play later
Lists
Like
Liked
14:21In 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/ Want to…
…
continue reading
1
A million transactions per second: building TigerBeetle with Joran Greef
1:28:12
1:28:12
Play later
Play later
Lists
Like
Liked
1:28:12In this episode, Aaron talks with Joran Greef, CEO and creator of TigerBeetle, the world’s first financial transactions database. Joran takes us on a deep dive of on how TigerBeetle brings double-entry accounting principles directly into the database layer to achieve extreme correctness, performance, and fault tolerance at scale. Follow Joran and T…
…
continue reading
1
AI-Powered Migration plus Raw Experience with Mike Rousos
36:25
36:25
Play later
Play later
Lists
Like
Liked
36:25On this episode of Hanselminutes, Scott Hanselman talks with cloud migration and app modernization expert Mike Rousos about the challenges and opportunities of bringing decades-old applications into the modern era. They discuss practical strategies for app modernization, how AI and GitHub Copilot are reshaping developer workflows, and what it takes…
…
continue reading
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/ Want to le…
…
continue reading
There are cases where the backend may need to close the connection to prevent unexpected situations, prevent bad actors or simply just free up resources. Closing a connection gracefully allows clients and backends to clean up and finish any pending requests. In this episode of the backend engineering show I discuss graceful connections in both HTTP…
…
continue reading
Nik and Michael discuss lightweight locks in Postgres — how they differ to (heavier) locks, some occasions they can be troublesome, and some resources for working out what to do if you hit issues. Here are some links to things they mentioned: Wait Events of Type LWLock https://www.postgresql.org/docs/current/monitoring-stats.html#WAIT-EVENT-LWLOCK-…
…
continue reading
1
The Game Designers Workbook with Bobby Lockhart
34:43
34:43
Play later
Play later
Lists
Like
Liked
34:43On this episode of Hanselminutes, Scott talks with Bobby Lockhart, game designer and coauthor of The Game Designer’s Workbook. They explore the craft of game design, from turning ideas into playable experiences to balancing creativity with structure, and discuss how the principles in the workbook can help both aspiring and seasoned designers build …
…
continue reading
1
Boosting Planning Performance | Scaling Postgres 387
15:54
15:54
Play later
Play later
Lists
Like
Liked
15:54In 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/epi…
…
continue reading
1
The Fundamental Interconnectedness of All Things with Boriss Mejías
1:18:14
1:18:14
Play later
Play later
Lists
Like
Liked
1:18:14What do chess clocks, jazz, and Postgres replication have in common? In Episode 32 of Talking Postgres, solution architect Boriss Mejías shares how the idea of “interconnectedness”—inspired by Douglas Adams—can help you untangle complex Postgres questions. We explore OpenAI’s approach to scaling Postgres, how Postgres active-active mirrors Sparta’s…
…
continue reading
1
Competence builds confidence with .NET Principal Engineer Safia Abdalla
36:00
36:00
Play later
Play later
Lists
Like
Liked
36:00On this special episode of Hanselminutes, Scott reunites with .NET Principal Engineer Safia Abdalla, nearly 500 episodes and a decade after her first appearance on the show. They reflect on the arc of her career and the evolution of the developer landscape, discussing how building competence fuels confidence, how anxieties can compound in high-pres…
…
continue reading
1
Block Bad Data Before the Write with Nike’s Ashok Singamaneni
20:20
20:20
Play later
Play later
Lists
Like
Liked
20:20By The Firebolt Data Bros
…
continue reading
1
Postgres 18: The Deep Cuts | Scaling Postgres 386
15:03
15:03
Play later
Play later
Lists
Like
Liked
15:03In 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/ Want…
…
continue reading
Postgres 18 has been released with many exciting features such as UUIDv7, Over explain module, composite index skip scans, and the most anticipated asynchronous IO with worker and io_uring mode which I uncover in this show. Hope you enjoy it 0:00 Intro 1:30 Synchronous vs Asynchronous calls 3:00 Synchronous IO 6:30 Asynchronous IO 10:00 Postgres 17…
…
continue reading