Talking Postgres with Claire Giordano

Magnus Hagander’s lucky break with Postgres: getting to have his job be his hobby, and his hobby be his job. In Episode 45 of Talking Postgres, Magnus—PostgreSQL committer, core team member, chair of PostgreSQL Europe, and longtime PGConf.EU organizer—walks Claire through how he got started in Postgres in the late 90s. We dig into porting the Postgres database server to Windows across three time zones, being told the project was doomed unless it moved to SourceForge (ha!), and why it’s harder to become a Postgres committer today. Of course we talk about the conferences he helps run: PGConf.EU, Nordic PGDay, and FOSDEM PGDay 2027. Plus: his first patch (one line, and it doesn’t carry his name) and why you shouldn’t have an AI agent write your patch. Previously on Talking Postgres:Talking Postgres podcast Ep20: How I got started as a developer (& in Postgres) with Tom LaneTalking Postgres podcast Ep19: Becoming a Postgres committer with Melanie PlagemanLinks mentioned in this episode:Event: PostgreSQL Anniversary Summit, in Toronto on 8-9 Jul 2006PGConf.dev 2025 talk: postgresql.org: The hidden parts, by Magnus HaganderFOSDEM PGDay 2026 talk slide: Who serves on the Postgres sysadmin team, by Claire GiordanoBoard of Directors: PostgreSQL Europe non-profitKeynote at the first POSETTE (then called Citus Con): PostgreSQL—more relevant than ever, by Magnus HaganderPostgreSQL mailing list: Tom Lane’s 2006 email on the name PostgreSQLDiscord: PostgreSQL Development DiscordConference: PGConf.EU 2026 in ValenciaTwo days this time: FOSDEM PGDay 2027, on 28 & 29 Jan 2027Conference: FOSDEM 2027 in Brussels, on 30 & 31 Jan 2027Conference: Nordic PGDay 2027 in Stockholm, on 16 Mar 2027Conference: PGConf.dev 2027 in Montréal, on 11-14 May 2027Conference: POSETTE: An Event for Postgres 2027, happening 30 & 31 Mar 2027Conference: SCaLE 24x in Pasadena, happening 1-4 Apr 2027In this episode, we covered:00:00 Intro & music03:13 The internet showed up09:36 A one-line patch so Postgres would compile on Linux12:53 Porting Postgres to Windows across 3 continents18:32 PostgreSQL Europe was founded at FOSDEM25:06 If that's our biggest mistake, we're doing fine28:47 First Nordic PGDay: booked for 50, got 10033:11 Trying a smaller Nordic event in Gothenburg38:31 Self-hosting Postgres infrastructure47:19 Battling AI agents that ignore robots.txt50:25 From a bar in a city wall to 750 attendees56:26 Announcing the next PGConf.EU location58:22 The lucky break: when my hobby became my job1:00:24 What keeps Magnus coming back to Postgres1:02:26 It’s harder to become a committer today1:09:15 Don't just have an AI agent write your patch

Karen Jex, a senior software engineer at Snowflake and major PostgreSQL contributor, recounts her accidental start as an Oracle DBA and unexpected leap into Postgres. She shares the culture shock of building backups and high availability from scratch, moving to the French Alps for mountain biking, and finding a welcoming open-source community. They also explore conference organizing, mentoring newcomers, storytelling, and AI-assisted engineering.

Peter Eisentraut, a PostgreSQL committer, core team member, SQL standards contributor, and EDB chief architect, reflects on 25 years in the project. He traces his path from Commodore 64 tinkering and a psql tab-completion fix to shaping releases, mentoring contributors, and strengthening community governance. They also explore conferences, silent users, the EU Cyber Resilience Act, and the responsibility of code used worldwide.

Simon Willison, independent open-source developer and co-creator of Django who builds tools like Datasette, discusses how AI reshapes software work. He tells stories of agent-driven prototypes, using TDD to make agents reliable, and triaging PRs with bots. He stresses explainability before shipping, managing AI agents like teams, and how understanding code is now the hard part.

What happens when a database engineer spends 13 years on SQL Server and then starts working on Postgres? In Episode 41 of Talking Postgres, Distinguished Engineer Panagiotis “Panos” Antonopoulos of Microsoft joins Claire to share what surprised him most about making that transition. We explore why Postgres felt familiar from the start—and what shocked Panos about the clean and lean Postgres codebase. We also dig into how public mailing lists and AI can help explain why design decisions were made, why more people are asking “why not Postgres?”, and the shared-storage architecture behind Azure HorizonDB.Previously on Talking Postgres:Talking Postgres Ep 39: From MemSQL to HorizonDB, an engineer's journey with Adam ProutTalking Postgres Ep 38: How I went from Oracle to Postgres (with a big NoSQL detour) with Gwen ShapiraTalking Postgres Ep 40: How I got started running a Postgres user group with Jeremy SchneiderLinks mentioned in this episode:SIGMOD: ACM SIGMOD-PODS Conference 2027  CMUDB talk: HorizonDB: Co-Designing Postgres and Azure for Cloud-Native OLTP, by Adam ProutPostgreSQL mailing list: pgsql-hackersPostgreSQL docs: pg_stat_slru (simple least-recently-used)Docs: Azure HorizonDBPoster: Postgres Happiness Hints

Intensely local user groups have been part of Jeremy Schneider's story from the start—from Linux meetups at a Michigan coffee shop to a closet server running an Oracle database nobody knew anything about. In Episode 40 of Talking Postgres, Postgres engineer and Seattle Postgres User Group co-organizer Jeremy Schneider joins Claire to share how community led him to Postgres after 15 years with Oracle—and why "it's like I was born to be here." Plus: the newly-updated Postgres Happiness Hints poster, advice for starting your own user group, and his POSETTE 2026 talk on CloudNativePG.Previously on Talking Postgres:Talking Postgres Ep 38: How I went from Oracle to Postgres (with a big NoSQL detour) with Gwen ShapiraLinks mentioned in this episode:Seattle Postgres User Group: Meetup pageSeattle Postgres User Group: YouTube channelUser Group Map from PGConfEU 2025 talk: 48 Postgres User Groups during PG18 timeframePostgreSQL.org: Listing of local Postgres User GroupsPostgres Meetup For All (a virtual meetup): Meetup pageJeremy Schneider’s Blog: Ardent Performance ComputingPoster: Postgres Happiness HintsPGConf.dev 2026: Posters from Poster SessionPGConf.dev 2026 Poster Session: Talking Postgres posterPOSETTE: An Event for Postgres 2026: Jeremy’s POSETTE 2026 talk with Leonardo CecchiPOSETTE 2026: Livestream 3 schedule & talksOracle docs: Oracle Database Concepts PDFBook: Oracle Insights: Tales of the Oak Table

What does it take to make Postgres and Azure fit together cleanly, like puzzle pieces? In Episode 39 of Talking Postgres, Adam Prout—distinguished engineer at Microsoft and a founding architect of Azure HorizonDB—joins Claire to trace his engineering journey from MemSQL to Postgres. We dig into shared-storage architecture and how HorizonDB pushes more work into the storage layer; why the team chose Rust; and what “good systems programming” looks like when being paranoid is a feature, not a bug. Along the way: startup vs big company tradeoffs, and how working on databases exposes you to so many interesting parts of computer science.  Previously on Talking Postgres:Talking Postgres Ep29: How I got started leading database teams with Shireesh ThotaLinks mentioned in this episode:Blog post: Announcing Azure HorizonDB, by Charles Feddersen & Affan DarCMUDB talk: HorizonDB: Co-Designing Postgres and Azure for Cloud-Native OLTP, by Adam ProutResearch paper: Socrates: The New SQL Server in the CloudProduct page: Azure HorizonDBVideo of POSETTE 2025 talk: Scaling Postgres to the next level at OpenAIBlog post: Scaling PostgreSQL to power 800 million ChatGPT users, by Bohan ZhangBlog post: Supporting ChatGPT on PostgreSQL in Azure, by Affan Dar, Adam Prout, & Panagiotis Antonopoulos Docs: Azure Database for PostgreSQLGitHub repo: pgrxDiscord: PostgreSQL Hacking serverConference: PGConf.dev 2026Conference Schedule: PGConf.dev 2026 Schedule

It’s rare for developers to genuinely love their database, so why does Postgres earn that kind of loyalty? In Episode 38 of Talking Postgres, Gwen Shapira, co‑founder of Nile, joins Claire to trace her path from operating Oracle at scale, through a long NoSQL chapter, to co‑founding a Postgres company that wasn’t originally meant to be one—after discovering how much Postgres quietly gets right. Gwen shares how she spun up on Postgres after years with other databases (shout-out to the Happiness Hints and a strong sense of curiosity), and why Postgres has made her appreciate Codd. We also touch on blogging as a career catalyst, the upcoming PGConf.dev conference (where a lot of PG20 work gets discussed, and where we’ll celebrate 30 years of Postgres)—and the #1 rule of consulting: it’s always the consultant’s fault. Previously on Talking Postgres:Talking Postgres Ep15: My Journey to Explaining Explain with Michael ChristofidesTalking Postgres Ep24: Why mentor Postgres developers with Robert HaasTalking Postgres Ep30: AI for data engineers with Simon WillisonLinks mentioned in this episode:Gwen’s company: NileArdent Performance Computing blog: PostgreSQL Happiness HintsBook: Just Use Postgres! by Denis MagdaGitHub repo: HypoPGWikipedia page: Codd’s 12 rulesBlog post: Transaction Isolation in Postgres, by Gwen ShapiraPodcast: Postgres.FMDiscord server: PostgreSQL Hacking Upcoming conferences & talks mentioned:Conference: PGConf.dev 2026 on May 19-22 in Vancouver CanadaConference Schedule: PGConf.dev 2026 scheduleCFP deadline: PGConf.dev Community Discussion Sessions deadline on 14 Apr 2026Conference: PGConf EU 2026 in Valencia SpainLinkedIn post: PGConf.dev 2026 conference t-shirt, celebrating 30 years of PostgresPOSETTE 2026 talk: The Rise of PostgreSQL as the Everything Database, by Varun DhawanPGConf.dev 2026 Panel: Real-Time Patch Idea EvaluationPGConf.dev 2026 Roundtable: Unexpected Successes & Epic Failures by PostgreSQL committers

Why does SQL feel so approachable to some developers, and why do some of them end up spending their careers in the data layer? In Episode 37 of Talking Postgres, Charles Feddersen, who leads product for Postgres at Microsoft, joins Claire to talk about building Postgres services on Azure. We explore his path from classic ASP apps on Microsoft Access to distributed Postgres with Citus, the moment he installed pgAdmin and got pulled deeper into Postgres, and what it takes to build for the many different ways people rely on Postgres today—from Flexible Server and Azure HorizonDB to developer tooling—and why it’s important to support the upstream Postgres open source project.Previously on Talking Postgres:Ep 22: Leading engineering for Postgres on Azure with Affan Dar: https://talkingpostgres.com/episodes/leading-engineering-for-postgres-on-azure-with-affan-darEp29: How I got started leading database teams with Shireesh Thota https://talkingpostgres.com/episodes/how-i-got-started-leading-database-teams-with-shireesh-thotaLinks mentioned in this episode:Video of CMUDB talk: HorizonDB: Co‑Designing PostgreSQL and Azure for Cloud‑Native OLTP, by Adam ProutVideo of talk: Azure HorizonDB: Deep Dive into a New Enterprise-Scale PostgreSQL, by Adam Prout & Denzil RibeiroTalk at SCALE 23x: Did VS Code Quietly Become a Go-To Postgres Tool?, by Phil Vacca Visual Studio Code Marketplace: VS Code extension for PostgreSQLDocs: Azure Database for PostgreSQL – Flexible ServerGitHub repo: Citus open sourcePostgres extension: PostGISConference: PGConf India 2026Upcoming conferences & talks mentioned:Conference: PGConf.dev 2026 in Vancouver CanadaConference: Microsoft Build 2026Keynote at POSETTE: An Event for Postgres 2026: Driving Postgres forward at MicrosoftPOSETTE: An Event for Postgres 2026: ScheduleConference: Postgres Summit US 2026 (formerly PGConf NYC)Conference: PGConf EU 2026 in Valencia

Tomas Vondra, a PostgreSQL committer focused on query planning and performance, explores why chasing slow queries can be so rewarding. They discuss meaningful real-world puzzles, surprising wins from tiny code changes, benchmarks as investigative tools, and the mathematics behind database tradeoffs. Tomas also shares stories of community, mentorship, workshops, and the satisfaction of solving stubborn performance problems.