The Fundamental Interconnectedness of All Things with Boriss Mejías
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 dual kingship, and how a holistic approach can reveal the behavior of synchronous replication. Also: Beethoven’s 17 drafts, and why chasing perfection can hold you back. Listen to learn more about Boriss, Postgres, and the fundamental interconnectedness of all things.Links mentioned in this episode:Podcast Ep32 of Talking Postgres: What went wrong (& what went right) with AIO with Andres FreundPodcast Ep03 of Talking Postgres: Why give talks at Postgres conferences with Álvaro Herrera & Boriss Mejías: Wikipedia: Dirk Gently’s Holistic Detective Agency, by Douglas AdamsTalk at PGConf NYC 2025: Scaling Postgres to the Next Level at OpenAI, by Bohan ZhangVideo of PGConf.dev 2025 talk: Scaling Postgres to the Next Level at OpenAI, by Bohan ZhangTalk at PGConf NYC 2025: Improved Freezing in Postgres Vacuum: From Idea to Commit, by Melanie PlagemanTalk at PGConf NYC 2025: Database Modeling to Study the New York Jazz Scene, by Boriss MejíasJazz Club in NYC: Patrick’s Place in HarlemVideo of PGConf EU 2024 talk: Sparta’s Dual-Kingship and PostgreSQL Active-Active, by Boriss Mejías Video of POSETTE 2025 talk: Postgres Storytelling: Cunning Schema Design with Creative Data Modeling, by Boriss Mejías & Sarah Conway Talk at FOSDEM PGDay 2024: High Availability Configurations Are Very Common for PostgreSQL, But How Do You Investigate Performance Problems When the Standby Can’t Keep Up? by Boriss Mejías and Derk van VeenConference: PGDay Lowlands 2025, the second year of this “second-best Postgres conference in Europe” Conference Schedule: upcoming PGConf EU 2025 in LatviaWikipedia: Chess clockBook: Daily Rituals, by Mason CurreyArticle: It Takes Two to Think, by Itai Yanai & Martin J. LercherPoem: The Rime of the Ancient Mariner, by Samuel ColeridgeWikipedia: City of Bruges Belgium, a good place for beer and cheeseCal invite: LIVE recording of Ep33 of Talking Postgres to happen on Wed Nov 5, 2025
--------
1:18:14
--------
1:18:14
What went wrong (& what went right) with AIO with Andres Freund
Six years, a prototype, and a brief multi-layered descent into “wronger and wronger” design—what does it take to land a major architectural change in Postgres? In Episode 31 of Talking Postgres, Andres Freund—major contributor, Postgres committer, and lead of the Asynchronous I/O project—shares the wins, the missteps, and why he thinks AIO definitely took too long. We dig into io_uring in Linux, direct I/O, streaming reads, technical leadership, and exactly when is the right time to stop working on a prototype. If you’ve ever wondered how big architectural changes happen, or why they sometimes take years, this episode is for you. Links mentioned in this episode:Talking Postgres podcast: How I got started as a developer (& in Postgres) with Andres Freund & Heikki LinnakangasRelease Notes: PostgreSQL 18 release notes News: PostgreSQL RC 1 Released on Sep 04 2025Wikipedia page: io_uringPostgreSQL: Join the PostgreSQL Hacking DiscordVideo of talk: What went wrong with AIO by Andres Freund at PGConfdev 2025Commit: Add core asynchronous I/O infrastructure to PostgreSQLWiki page: AIO project in PostgreSQL with state, sub-projects, and work still to be doneUpcoming Talk: AIO in PG 18 and Beyond at PGConf NYC on 30 Sep 2025Upcoming Talk: AIO in PG 18 and Beyond at PGConf EU on 23 Oct 2025Wikipedia page: XZ Utils backdoor discovery by Andres FreundCal invite: LIVE recording of Ep32 of Talking Postgres to happen on Wed Oct 8, 2025
--------
1:12:46
--------
1:12:46
Talking Postgres with Claire Giordano – Trailer
Why do Postgres developers, contributors, and users do what they do? In each episode of Talking Postgres, Claire Giordano talks to people from across the Postgres ecosystem—how they got started, what they’ve learned, and what they’re still figuring out. This 3-minute trailer offers a fast-paced glimpse into the fun, surprising, and deeply human stories behind Postgres, including failures, wins, obstacles—and all the messy parts in between. New episodes monthly. Always on Fridays. Subscribe wherever you get your podcasts.Episodes from Talking Postgres with guests featured in the trailer (in order of appearance): Episode 01: Working in public on open source with Simon Willison and Marco SlotEpisode 18: How I got started as a developer (& in Postgres) with David RowleyEpisode 20: How I got started as a developer (& in Postgres) with Tom LaneEpisode 07: Why people care about PostGIS and Postgres with Paul Ramsey & Regina ObeEpisode 29: How I got started leading database teams with Shireesh ThotaEpisode 25: Why Python developers just use Postgres with Dawn WagesEpisode 19: Becoming a Postgres committer with Melanie PlagemanEpisode 24: Why mentor Postgres developers with Robert HaasEpisode 04: How I got started as a dev (& in Postgres) w/Melanie Plageman & Thomas Munro
--------
2:53
--------
2:53
AI for data engineers with Simon Willison
It’s always a good day if you see a pelican. In Episode 30 of Talking Postgres with Claire Giordano, open source developer Simon Willison—creator of Datasette and co-creator of Django—joins to explore how AI is useful for data engineers today. We move past the hype and boosterism to dig into example after example: structured data extraction, alt text and accessibility, safety and security (aka the fiddly bits), and why Postgres’s fine-grained permissions are such a good fit for AI-powered workflows. Also: Pulitzer-worthy data tooling, the science fiction of the 10X engineer, agents, MCP, RAG, the multitude of models, and why Simon spends so many waking hours on the jagged frontier of AI.Links mentioned in this episode:Blog: Simon Willison’s WeblogBlog: Simon’s Willison’s TIL - Things I’ve LearnedPodcast episode: Working in public on open source with Simon Willison and Marco SlotProject page: Django Web FrameworkProject page: Datasette, for finding stories in data GitHub repo: llm CLI tool and Python libraryDemo: Language models on the command-line w/ Simon WillisonBlog post: OpenAI’s new open weight (Apache 2) models are really good, by Simon Willison Podcast episode: Accessibility and Gen AI podcast with guest Simon WillisonBlog post: New dashboard: alt text for all my images, by Simon Willison Keynote talk: Big Opportunities in Small Data, by Simon Willison at Citus Con: An Event for Postgres 2023 Blog post: How OpenElections Uses LLMs, by Derek Willis Blog posts tagged with pelican-riding-a-bicycle on Simon Willison’s Weblog Blog post: No, AI is not Making Engineers 10x as Productive, via Colton Voege, featured on Simon’s weblogGitHub repo: pgvector extension to PostgresCal invite: LIVE recording of Ep31 of Talking Postgres to happen on Wed Sep 17, 2025
--------
1:15:58
--------
1:15:58
How I got started leading database teams with Shireesh Thota
From dreaming of driving a bus to leading database engineering at Microsoft. In Episode 29 of Talking Postgres with Claire Giordano, Shireesh Thota traces his path to becoming CVP of Azure databases—rooted in a love of math, early BASIC programming, and a certainty that he’d become an engineer. We dig into the shift from engineer to manager (if only people came with documentation); why it’s so important for Microsoft to contribute to the PostgreSQL open source project—not just consume it; and whether Shireesh has a favorite database (hint: it better be Postgres.)Links mentioned in this episode:Blog post excerpt: Why we have a Postgres open source contributor team at MicrosoftPodcast episode: Leading engineering for Postgres on Azure with Affan DarVS Code Marketplace: New VS Code extension for PostgreSQLPOSETTE 2025 talk: Introducing Microsoft’s VS Code extension for Postgres by Matt McFarlandLinkedIn post: PGConf.dev 2025 talk on “The trouble with extensions” by Marco SlotPodcast episode: How I got started as a developer (& in Postgres) with David RowleyBook: Who Moved My CheeseCal invite: LIVE recording of Ep30 of Talking Postgres to happen on Wed Aug 6, 2025
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 fun!): https://aka.ms/TalkingPostgres-cal
UK