Talking Postgres with Claire Giordano

How does a fix for psql tab completion turn into 25 years of contributing to Postgres? In Episode 43 of Talking Postgres, Peter Eisentraut—PostgreSQL committer, core team member, SQL standards contributor, and Chief Architect of Database Servers at EDB—joins Claire to trace that journey. We dig into how scratch-your-own-itch development drew him in, why “the things you do, people welcome them” kept him coming back, and how Postgres changed as it grew from a small database community into a massive ecosystem where, from the Postgres mailing list perspective, “most of the user base is silent.” Plus: what it feels like when code you commit goes straight to everybody who uses Postgres, and the implications of the EU Cyber Resilience Act.

Previously on Talking Postgres:

Links mentioned in this episode:

In this episode, we covered:

00:00 Intro & music

02:14 Tinkering with the Commodore 64 

07:57 The itch that became psql tab completion

15:43 Had to make opportunities

23:05 From posting at night to posting during the day

24:40 Why he stopped committing in the afternoon

28:04 On the ground floor of something that grew

30:34 What the Postgres core team actually does

31:47 Borrowing ideas from other OSS projects

36:51 Bringing Postgres into the SQL standards process

38:40 Getting to hang out with database nerds

42:01 Mentoring Postgres contributors

50:56 Making time for Postgres conferences

53:35 What the Cyber Resilience Act means for Postgres

57:36 Where are all the Postgres users?

1:07:00 Becoming a committer early on in Postgres

1:16:22 Contributing to Postgres isn't just writing code

1:19:40 Why FOSDEM is still his favorite

1:22:15 Finding familiar problems in a compiler devroom

1:26:14 Shout-out to the Planet Postgres feed

What’s your gold standard for deciding whether AI-written code is ready for production? In Episode 42 of Talking Postgres, Simon Willison—creator of Datasette, co-creator of Django, and prolific open-source developer—joins Claire to share how AI is changing the way he builds software today. We dig into why his test for shipping AI-generated code is “Could I explain this to somebody else?”, how engineering management skills can be surprisingly useful when managing AI agents, and how the bottleneck is no longer writing code but understanding it. Also: personal credibility, deep research, the Winchester Mystery House, slop proxies, and Simon’s observation that “Features are cheap. That doesn’t mean you should build them all.”

Previously on Talking Postgres:

Links mentioned in this episode:

In this episode, we covered:

00:00 Intro & music

04:00 A week of work before breakfast

09:12 Red-green TDD makes agents exercise every line

14:42 A million lines mean nothing if you don’t understand it

18:28 Finding low-hanging fruit among open PRs & issues

22:07 Getting work done while walking the dog

23:01 Gold standard: “Could I explain this to somebody else?”

28:27 Slop proxies add no value at all

30:49 Aggressive nitpicking reviews

35:01 Everything in software engineering is about trade-offs

41:16 Racoon heist game is only fun for 1 minute 15 seconds

43:46 New Year’s resolution to be more ambitious

48:11 You have to learn to throw things away

51:57 Features are cheap. That doesn’t mean you should build them all

1:00:45 Engineering management skills are so useful

1:04:44 QA specialists should be having a great time

1:07:53 Writing is thinking, don’t outsource it

1:08:23 Skill atrophy is a choice you make

1:10:07 I believe in people who are motivated

1:11:55 Systems are not set up to deal with this volume

1:18:48 Research agents stopped being absolute garbage

1:21:49 The whole point of the “human in the loop”

1:26:10 Dream: I want there to be more small businesses

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:

Links mentioned in this episode:

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:

Links mentioned in this episode:

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:

Links mentioned in this episode:

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:

Links mentioned in this episode:

Upcoming conferences & talks mentioned:

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:

Links mentioned in this episode:

Upcoming conferences & talks mentioned:

Why would anyone willingly spend weeks chasing a slow query, knowing they might hit dead ends along the way? In Episode 36 of Talking Postgres, Tomas Vondra—Postgres committer and long‑time performance contributor—joins Claire to explain why hacking on Postgres performance is not just hard, but also fun. We dig into the process of investigating why queries are slow, how iteration and “wrong turns” are part of performance work, and why Tomas prefers meaningful performance puzzles over toy problems. Along the way, we talk about using benchmarks to build an understanding of a problem. Tomas also shares how even small changes in code can have outsized impact when that code is used a lot, and how the mathematics embedded in the Postgres query planner/executor makes the work especially rewarding.

Previously on Talking Postgres:

Links mentioned in this episode:

Are self-driving databases the Waymos of the future? In Episode 35 of Talking Postgres, Luigi Nardi—founder and CEO of DBtune and Stanford researcher—joins Claire Giordano to explore his journey from academic research to Level 5 autonomous database tuning. We dig into Luigi’s early days with a Commodore 64, how he began his PhD in Paris before he had learned to speak French, and how "professor privilege" in Sweden helped him bootstrap his startup. You’ll learn why the DBtune team chose database tuning and Postgres as their focus, what the Jevons paradox means for the future of developers, and how the “Level 5” vision fuels the DBtune team’s work toward a truly self-driving system.

Previously on Talking Postgres:

Links mentioned in this episode:

What do conference planning, hacking weddings, and cat-free coding sessions have to do with Postgres? In Episode 34 of Talking Postgres, Melanie Plageman—Postgres committer and major contributor from Microsoft—joins Claire for a lively deep dive into what developers can expect at PGConf.dev 2026 as Postgres turns 30. We explore new content formats, the role of travel grants, why Tuesday becomes a full conference day, and how the hallway track often shapes the next Postgres release. Plus: creating space for new contributors to get inspired and get involved. And yes—the CFP is open until Jan 16, 2026.

Links mentioned in this episode:

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, and how Rob now codes in English—and then spends even more time in code review to decide what’s good, what’s bad, and what’s dangerous. Also: how PyCon changed his life; his work on the Microsoft Planetary Computer with spatio-temporal queries and PostGIS; and how music, improv, and failure shape his approach to developer experience. 

Links mentioned in this episode:

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:

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:

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 Slot

Episode 18: How I got started as a developer (& in Postgres) with David Rowley

Episode 20: How I got started as a developer (& in Postgres) with Tom Lane

Episode 07: Why people care about PostGIS and Postgres with Paul Ramsey & Regina Obe

Episode 29: How I got started leading database teams with Shireesh Thota

Episode 25: Why Python developers just use Postgres with Dawn Wages

Episode 19: Becoming a Postgres committer with Melanie Plageman

Episode 24: Why mentor Postgres developers with Robert Haas

Episode 04: How I got started as a dev (& in Postgres) w/Melanie Plageman & Thomas Munro

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:

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:

What drives someone to publish 600+ issues of a Postgres newsletter for over a decade? In Episode 28 of Talking Postgres with Claire Giordano, Peter Cooper—creator of Postgres Weekly—shares how his days of rustic programming and QBASIC fanzines on Usenet led to a newsletter empire that now reaches nearly half a million developers each week. We dig into the BBC's "big tent" editorial influence, an accidental business model that just worked, and the perils of "temporary" hacks. Plus: spam filters, a Photoshop addiction, and one very cheesy story (dairy-free).

Links mentioned in this episode:

How does a trek to K2 base camp in the Himalayas spark the idea for a database company? In Episode 27 of Talking Postgres with Claire Giordano, guest Peter Farkas—CEO and co-founder of FerretDB—shares the origin story of this open source MongoDB alternative. (Spoiler: “Ferret” wasn’t the original name). We dig into why Postgres was the obvious choice, what “true open source” means to Peter, and how FerretDB is now powered by the open source DocumentDB extension from Microsoft. Plus, why Hungarian Trappist cheese might deserve a footnote in database history.

Links mentioned in this episode:

What does it take to lead a global open source project like Postgres? In Episode 26 of Talking Postgres with Claire Giordano, we sit down with Bruce Momjian—co-founder and core team member of the PostgreSQL Global Development Group—to explore the art of leadership in a volunteer-run open source community. Bruce shares what “servant leadership” really means; how saying I’m sorry can help make problems go away; and how letting go of who-gets-the-credit can fuel collaboration. We also dive into Bruce’s origin story, from shaping Postgres’s early days to mastering the art of public speaking. Pro tip: if you see a man in a bow tie at a Postgres conference, be sure to say hello—it’s probably Bruce Momjian!

Links mentioned in this episode:

When I found out that Django developer and Python Software Foundation chair Dawn Wages has a chapter in her upcoming Domain-Driven Django book called “Just Use Postgres”, I knew we had to get her on the show. In this episode of Talking Postgres with Claire Giordano, Dawn breaks down why so many Python and Django developers have such an affinity for Postgres. And we dive into the Djangonaut Space mentoring program (where contributors launch), learn why “free as in puppies” beats “free as in cake” for open source vibes, and dig into why Python is the second-best language for everything.

Links mentioned in this episode:

Nobody works on an open-source project forever—eventually, people move on. So of course today's Postgres contributors want to see more developers join the project, pick up the torch, and continue to make Postgres amazing. Hence the importance of mentorship. In this episode of Talking Postgres with Claire Giordano, PostgreSQL major contributor and committer Robert Haas shares how he learned the ropes in Postgres by channeling “what would Tom Lane do” during patch reviews; why he launched the new PostgreSQL Hackers Mentoring program; and the intellectually stimulating care and feeding it takes to make Postgres thrive.

Links mentioned in this episode:

March 5th 2005 at 3 PM in Copenhagen. That’s the exact time and place Daniel Gustafsson’s career took an unexpected turn, pivoting from operating systems to databases. At LinuxForum that day, Daniel had planned to meet up with the FreeBSD community, but a chance session about Postgres by Bruce Momjian completely blew his mind. By the time Daniel was on the train back to Malmö, he was already compiling Postgres. In this episode of Talking Postgres with Claire Giordano, Postgres major contributor and committer Daniel Gustafsson of Microsoft walks us through how he got his start as a developer and in Postgres—starting with his earliest computing memories of a hulking steel box in his family’s living room in Sweden. Also part of Daniel’s story: guitar tuning software. And curl!

Links mentioned in this episode:

What’s it like to lead Postgres engineering at a cloud giant like Microsoft Azure? In this episode of Talking Postgres, host Claire Giordano chats with Affan Dar, VP of Engineering for Postgres at Microsoft. Affan’s team is behind the Azure Database for PostgreSQL managed service and also contributes extensively to the upstream Postgres open-source project. Affan walks us through his career journey—from his first job as an embedded systems engineer, to navigating the shift between engineering and management, to leading one of the largest Postgres engineering teams in the world. He shares the strategy behind Microsoft’s investments into Postgres, explores how massive cloud fleets are influencing the future of Postgres, and shares what keeps him up at night.

Links mentioned in this episode:

Have you ever achieved something remarkable because someone planted an idea in your mind? In this episode of Talking Postgres, host Claire Giordano talks with Andrew Atkinson—a Rails developer and Postgres user whose journey to becoming a published author began with a simple seed of inspiration. Andrew’s story started with an internal presentation on how to tackle tricky scalability challenges in Rails, grew into a Postgres conference talk at PGConf NYC—and ultimately evolved into his book, High Performance PostgreSQL for Rails. Also in this episode: what does cheese have to do with Postgres? Is writing a good way to think? What’s the connection between Postgres and swimming to Antarctica? And which chapter of his book does Andrew love the most?

Links mentioned in this episode:

It was not Tom Lane’s plan to become a computer person. Tom’s plan was to be a pinball machine designer. And yet for the last 26 years Tom has been one of the most prolific engineering contributors to Postgres. In this episode of Talking Postgres with Claire Giordano, PostgreSQL luminary Tom Lane walks us through how he got his start as a developer and in Postgres—including his time working on desktop calculators at HP. And how he has code running on Mars (and most of us don’t.) During Tom’s PhD studies at Carnegie Mellon, nobody told him databases were so interesting! It wasn’t until Tom needed a database to store stock trading information that he first got to work with Postgres. And that’s when Tom’s 26-year-long (and counting) Postgres story began.

Links mentioned in this episode:

If you could work on anything, would you quit your job to pursue it? Postgres committer and major contributor Melanie Plageman joined Claire Giordano on this episode of the Talking Postgres podcast (formerly Path To Citus Con) to share her story about becoming a Postgres committer. Melanie pivoted from IT consulting to open-source development, driven by her fascination with systems engineering and Postgres open source. What’s the secret to getting your patch committed? Feedback is a gift, but how willing are you to embrace it? How important is mentorship—and how important is it to ask for help? Even though crafting clear, concise emails to a technical community might not be easy, Melanie shows how empathy for other Postgres developers can help your work to stand out.

Links discussed in this episode

Podcasts & conference videos that Melanie listens to when running that she recommends to Postgres developers:

Ever wonder how driving a forklift at a cheese factory could lead to a career in databases? Postgres committer David Rowley joined Claire Giordano on this episode of the Talking Postgres podcast (formerly Path To Citus Con) to share his story about how he got started as a developer and in Postgres. Could an unexpected job lead to your dream career? Does speeding things up give you a buzz? How could an idea from a hike become a Postgres patch? And what is the importance of doing the research before you submit a proposal to the Postgres mailing list? Also discussed: resources available to start your Postgres journey such as books, blogs, videos, and the pgsql-hackers mailing list.

Links mentioned in this episode:

Have you ever eavesdropped on other people’s conversations? Former co-host Pino de Candia joins Claire Giordano on this episode of Talking Postgres (formerly Path To Citus Con) to share their experience on podcasting about Postgres. Is listening to a podcast the next best thing to being in the hallway track at a conference? Does it bring the community together? How beneficial has it been to have a parallel chat while recording live? What is the “sweet spot” for the number of guests to have per episode? Is structure important for a podcast? Also discussed: this podcast’s rename, a walk down memory lane reflecting on the past 16 episodes, and shout-outs to other podcasts about Postgres.

Links mentioned in this episode:

It’s not a conference unless you can confer, right? POSETTE organizers Teresa Giacomini and Aaron Wislang join Claire Giordano on the Path To Citus Con* podcast to share backstage perspectives on the making of POSETTE: An Event for Postgres. How do you feel about captions: love or hate? Should livestream talks be pre-recorded or presented live? Why rename from Citus Con to POSETTE? Where did the inspiration for POSETTE come from? And can the hallway track at a conference actually be fun—if it is virtual? Also discussed: Avett Brothers lyrics, the surprising number of POSETTE speakers with chickens, and the existential question of whether the work in organizing a conference is worth it.

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode: 

Did you know that sometimes the fastest way of doing something is not having to do it at all? In this episode of Path To Citus Con*, the podcast for developers who love Postgres, Michael Christofides joins Claire Giordano to chat about his journey to explaining explain (or should we say EXPLAIN!?) Michael shared his origin story as a mathematician and his first experience with Postgres before walking us through co-founding a Postgres company and now co-hosting a podcast. Like many in the Postgres community, he is opinionated in the best way possible! We even learned about his passion for BUFFERS and why he believes everyone should use them. This session also dives into Michael’s belief in the importance of Postgres documentation. Because great documentation can be worth its weight in Gold, especially when the going gets tough.

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode:

You have to find what works for you and Chris Ellis has never been the kind of person that could go and sit in a library—for Chris, the most productive Postgres place is in a coffee shop. In this episode of the Path To Citus Con* podcast for developers who love Postgres, Chris Ellis joined Claire and Pino to chat about his path to becoming more (and more) expert at using PostgreSQL. Curiosity may have killed the cat but it’s taken Chris places, beginning as a 5 year old playing with QBASIC. Chris shared his journey to becoming a developer, an electronic engineer, a builder, and a PostgreSQL user. This session also delves into Chris’s work as a Postgres conference speaker (and organizer!) Importantly, we spent time remembering Simon Riggs, Postgres leader extraordinaire. RIP.

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode:

Everywhere you look, people are talking about AI. From Copilot to ChatGPT to Postgres’s powerful AI capabilities (think: pgvector), AI is everywhere. In this episode of Path To Citus Con*, for developers who love Postgres, Arda Aytekin joined Claire and Pino to chat about spinning up on Postgres and AI. Arda shared his origin story in mechanical engineering and data science before walking us through vector databases, pgvector, and azure_ai. Arda is one of the creators of the azure_ai extension, so the conversation delves into the azure_ai integration between Azure Database for PostgreSQL and Azure AI Services. Also discussed (of course) was—Responsible AI.

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode:

The best days are when things don’t go as planned. Derk van Veen joined Claire Giordano and Pino de Candia on this episode of Path To Citus Con* podcast for developers who love Postgres—to discuss his journey from Java developer to PostgreSQL specialist and DBA. From his first days with DB2 and Oracle, to his work with Postgres, Derk shared how he learned about databases. And how a very smart colleague would break the database on purpose, to give Derk the tough job of fixing it. Another topic: what to do when you need to jump on a problem but your heart rate doubles? What will it take to get that magical feeling of fixing something in the database? And a segue into sharing your expertise as a speaker at Postgres conferences. Because it’s always about the why.

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode:

No one likes benchmarking. But it can be one of the highest impact things you do. Jelte Fennema-Nio and Marco Slot joined Claire Giordano and Pino de Candia on this episode of Path To Citus Con* podcast for developers who love Postgres—to discuss their journeys into performance benchmarking. And how it can change the course of your career. Do you need to find bottlenecks in your Postgres? Do you want to build skills with database benchmarks? There are many lovely benchmarking tools in the Postgres world: HammerDB, pgbench, YCSB, BenchBase, perf, & more. And in addition to running benchmarks themselves—asking the right questions, introspection, and profiling matter just as much.

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode:

Do you monitor your Postgres error logs for gold? Lukas Fittl and Rob Treat join Claire Giordano and Pino de Candia on the Path To Citus Con* podcast for developers who love Postgres—to discuss their respective journeys into Postgres monitoring. Have you ever asked yourself: “Why is my query so slow?” Or had to figure out which query is slowing things down? Or why your database server is at 90% CPU? There are so many ways to monitor Postgres: pganalyze, pgMustard, pgBadger, pgDash, your cloud provider’s Query Performance Insights, pg_stat_statements, pg_stat_io, & more. If you’re running Postgres on a managed service, what kinds of things do you need to monitor & optimize for (vs. what will your cloud service provider do)? There’s also a segue on monitoring vs. observability: what’s the difference? 

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode:

Is being lazy a good reason to learn SQL? Dimitri Fontaine and Vik Fearing join Claire Giordano and Pino de Candia on the Path To Citus Con* podcast for developers who love Postgres—to discuss whether every data problem can be (or should be) solved in SQL. Have you tried to solve all the Advent of Code puzzles with SQL? Or written a book for application developers about The Art of PostgreSQL? Or tried to solve a murder mystery by running SQL queries? Regardless of whether you pronounce SQL as “sequel” or as “ess-cue-ell”, getting skilled at SQL is like going to the gym for exercise. It’s ideal to do it every day to build up your strength. Also, this episode includes an explanation of what a “declarative” language like SQL is—plus a fun segue into time zones.

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode, in the order they were covered:

Lots of stories of how folks got started as developers! Andres Freund and Heikki Linnakangas join Claire Giordano and Pino de Candia to explore more paths for getting into Postgres on Path To Citus Con*, the podcast for developers who love Postgres. How do you do development: with a cup of coffee, with music in the background, maybe at 3am? How do you approach mentoring other developers? Why did you stick with Postgres and make it a career? Lots of lively discussion about building not only code, but relationships in the community, in the open. Also, stories about Heikki’s and Andres’s first Postgres patch submissions, and working via the hackers mailing list. Finally, what advice would you give to your younger self starting in the development world?

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode, in the order they were covered: 

The geospatial world of Postgres is so much more than mapping. Paul Ramsey and Regina Obe join Claire Giordano and Pino de Candia to explore the "where" on Path To Citus Con*, the podcast for developers who love Postgres. What are some of the unexpected use cases for PostGIS, one of the most popular extensions to Postgres? How have Large Language Models helped in the geospatial world? Can you really model almost anything with pgRouting? “Where” is the universal foreign key. They talk about communities and governments using geospatial data and how it's very difficult to build a database that does not have some sort of spatial component to it. Why do people care about PostGIS? Find out more about OpenStreetMap and its place in the open source geospatial world. Finally, Paul and Regina share the origin story for the PostGIS extension to Postgres.

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode, in the order they were covered:

Drop the fear, not the tables. Chelsea Dole and Floor Drees join Claire Giordano and Pino de Candia to explore the app developer perspective on Path To Citus Con*, the podcast for developers who love Postgres. If you’re an app developer, you’re probably already using Postgres. Now what? What do you need to know? Are databases your best friend or your worst enemy? They talk about the steps to becoming more Postgres-savvy. Should you go depth-first or breadth-first in order to learn more about the underlying database? What are Postgres extensions and how do you go about adopting them? Find out more about the strength of what Floor calls “boring technology.” Finally, both guests tell stories of their non-traditional entries into Postgres that led to their deep work with databases today.

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Links mentioned in this episode: 

Everyone learns differently. Grant Fritchey and Ryan Booz, database advocates at Redgate focusing on PostgreSQL, talk with Path To Citus Con* co-hosts Claire Giordano and Pino de Candia to explore the learning resources available to developers and users in all the corners of the PostgreSQL world. What drives you to learn: need or curiosity? What can podcasts teach us while we bike to work? Are conference talks good for growing skills, or are they better for networking? What about books? And do older books still have much to offer? It turns out, most people need much more than one approach to build their knowledge. 

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Some of the (many) links shared in the order they were mentioned: 

In this episode of Path To Citus Con*, Melanie Plageman, a PostgreSQL hacker working at Microsoft, and Thomas Munro, PostgreSQL developer and committer also at Microsoft talk with co-hosts Claire Giordano and Pino de Candia. They talk through all the different ways they got started as developers. Does making your first patch to Postgres get you hooked for a lifetime? Do you have to be a tinkerer to be a good software engineer? What is the “toothbrush test”—and how do you make your avocation be your vocation? We hear stories about dropping out of school or dropped out of career fields before they found their true passions in development and Postgres. 

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Some of the links mentioned in the order they were said: 

Álvaro Herrera, and Boriss Mejías, both longtime members of the Postgres developer community, explore the value of giving conference talks—as well as the work involved, the time it takes, and the many different types of conference talks, including presentations about about failure and things that have gone wrong.  

In this episode of Path To Citus Con*, Claire and Pino guide the conversation on questions like: Should you add humor to your talks? How does your personality—introvert or extrovert—affect your conference presentations? Is it OK to give the same conference talk at different events?  

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Some of the links mentioned in the order they appeared: 

Join Claire and Pino as they talk with Citus and Postgres open source team members to explore how to get Postgres ready for the next 100 million users. What will future Postgres users look like? How will the Postgres development process evolve with more users? What are the common challenges faced by Postgres users? 

 
Citus open source team members Abdullah Ustuner and Burak Yucesoy are joined by Postgres open source teammates Melanie Plageman and Samay Sharma—and co-hosts Claire Giordano and Pino de Candia—in this episode of Path To Citus Con*. Listen to the deep dive on what it means to scale the code and the community far beyond the Postgres world of today. 

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Some links from the show in the order they were mentioned: 

Simon Willison is the creator of Datasette and co-creator of Django. Marco Slot is the lead architect for the Citus database extension to Postgres. In this episode of Path To Citus Con*, Simon and Marco talk about working in public on open source. Simon shares many of his learnings in public—with weeknotes, tweets, blogs, and “today I learned” (TIL) posts. Marco has been developing Citus in public since it was first open sourced in 2016. 

Hosted by Claire Giordano and Pino de Candia from the Postgres team at Microsoft, listen to find out how working in public can help “future you”—and how there are selfish benefits to be had by working in open source. (Also: how to stay positive in the face of critics?) 

*[Update: July 2024] Path To Citus Con has been renamed to Talking Postgres. All of the past podcast episodes from Path To Citus Con—now called Talking Postgres with Claire Giordano—can be found here: https://talkingpostgres.com

Some of the topics covered in the order they were mentioned: