Search a title or topic

Over 20 million podcasts, powered by 

Player FM logo

Postgres Podcasts

show episodes
 
Artwork

1
Scaling Postgres

Creston Jamison

icon
Unsubscribe
icon
icon
Unsubscribe
icon
Weekly
 
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
 
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
 
Artwork

1
The Data Engineering Show

The Firebolt Data Bros

icon
Unsubscribe
icon
icon
Unsubscribe
icon
Monthly
 
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
 
Artwork

1
Rubber Duck Dev Show

Chris & Creston

icon
Unsubscribe
icon
icon
Unsubscribe
icon
Monthly
 
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
 
Artwork

1
The Coder Career

Cameron Blackwood

icon
Unsubscribe
icon
icon
Unsubscribe
icon
Monthly
 
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
 
Loading …
show series
 
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-…
  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
 
Postgres 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
 
In 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
 
Marcus 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
 
What 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
 
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 mor…
  continue reading
 
Scott 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
 
In 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
 
In 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
 
What 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
 
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/ 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
 
In 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
 
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/ Want to learn…
  continue reading
 
What 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
 
Aaron 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
 
Scott 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
 
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 perfor…
  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
 
This 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
 
In 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
 
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/ Want to…
  continue reading
 
In 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
 
On 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
 
On 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
 
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/epi…
  continue reading
 
What 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
 
On 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
 
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/ 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
 
Loading …
Copyright 2025 | Privacy Policy | Terms of Service | | Copyright
Listen to this show while you explore
Play