Leading engineering for Postgres on Azure with Affan Dar

Talking Postgres with Claire Giordano

Player FM - Internet Radio Done Right

הוסף לפני two שנים

תוכן מסופק על ידי Claire Giordano. כל תוכן הפודקאסטים כולל פרקים, גרפיקה ותיאורי פודקאסטים מועלים ומסופקים ישירות על ידי Claire Giordano או שותף פלטפורמת הפודקאסט שלהם. אם אתה מאמין שמישהו משתמש ביצירה שלך המוגנת בזכויות יוצרים ללא רשותך, אתה יכול לעקוב אחר התהליך המתואר כאן https://he.player.fm/legal.

<div class="span index">1</div> <span><a class="" data-remote="true" data-type="html" href="/series/the-vanished">The Vanished</a></span>

1
The Vanished

בטל רישום

לפני 22 ימיםלפני 22d ago

בטל רישום

חודשי

Join us on a journey into the perplexing world of disappearances, where individuals vanish without a trace, leaving behind a void filled with questions and speculation.

לפני שנה 1:05:52

MP3•בית הפרקים

Links mentioned in this episode:

Docs: Azure Database for PostgreSQL – Flexible Server
GitHub repo for Durable Task Framework, the first open source project Affan worked on
GitHub repo for pgvector open source extension to Postgres
Docs: Elastic cluster feature in Azure Database for PostgreSQL – Flexible Server, based on Citus
GitHub repo for Citus open source
Blog post: Postgres horizontal scaling with elastic clusters on Azure Database for PostgreSQL, by Adam Wølk
GitHub repo for DiskANN open source
Docs: How to enable and use the DiskANN index for Azure Database for PostgreSQL – Flexible Server
Blog post: Think of language models like ChatGPT as a “calculator for words” by Simon Willison
Blog post: What’s new with Postgres at Microsoft (updated 2x/year typically)
Video of Talk at Microsoft Ignite: Improving accuracy of GenAI apps with Azure Database for PostgreSQL by Maxim Lukiyanov (Microsoft), Jay Yang (UBS), & Orhun Oezbek (UBS)
CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 9 2025
Calendar invite: LIVE recording of Ep23 of Talking Postgres podcast to happen on Wed Jan 15, 2025 with guest Daniel Gustafsson

27 פרקים

#Tech #Postgres #Open Source #Citus #Ari Padilla #PostgreSQL #Database #Communities #Path To Citus

Leading engineering for Postgres on Azure with Affan Dar

Talking Postgres with Claire Giordano

published לפני שנה

שתפו

MP3•בית הפרקים

Links mentioned in this episode:

Docs: Azure Database for PostgreSQL – Flexible Server
GitHub repo for Durable Task Framework, the first open source project Affan worked on
GitHub repo for pgvector open source extension to Postgres
Docs: Elastic cluster feature in Azure Database for PostgreSQL – Flexible Server, based on Citus
GitHub repo for Citus open source
Blog post: Postgres horizontal scaling with elastic clusters on Azure Database for PostgreSQL, by Adam Wølk
GitHub repo for DiskANN open source
Docs: How to enable and use the DiskANN index for Azure Database for PostgreSQL – Flexible Server
Blog post: Think of language models like ChatGPT as a “calculator for words” by Simon Willison
Blog post: What’s new with Postgres at Microsoft (updated 2x/year typically)
Video of Talk at Microsoft Ignite: Improving accuracy of GenAI apps with Azure Database for PostgreSQL by Maxim Lukiyanov (Microsoft), Jay Yang (UBS), & Orhun Oezbek (UBS)
CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 9 2025
Calendar invite: LIVE recording of Ep23 of Talking Postgres podcast to happen on Wed Jan 15, 2025 with guest Daniel Gustafsson

27 פרקים

#Tech #Postgres #Open Source #Citus #Ari Padilla #PostgreSQL #Database #Communities #Path To Citus

Alla avsnitt

Talking Postgres with Claire Giordano

1
How I got started with FerretDB (& why we chose Postgres) with Peter Farkas 1:29:53

לפני 6 weeks1:29:53

1:29:53

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: GitHub: FerretDB/FerretDB repo Blog: FerretDB 2.0 GA: Open Source MongoDB alternative, ready for production ACM SIGMOD: The Design of Postgres, published 15 June 1986 Postgres Weekly: Issue 591 featuring FerretDB GitHub: Microsoft/DocumentDB open source repo Conference talk: From MongoDB to Postgres: Building an Open Standard for Document Databases at POSETTE 2025 OSI Blog: The SSL is Not an Open Source License RedMonk Blog: OSS: Two Steps Forward, One Step Back , by Stephen O’Grady Talking Postgres Ep18: How I got started as a developer (& in Postgres) with David Rowley OpenDocDB: initiative to define an open standard Wikipedia: K2 (yes, the mountain) Go Blog: The Go Gopher xkcd: webcomic 927 on Standards Wikipedia: Trappista cheese Cal invite: LIVE recording of Ep28 of Talking Postgres to happen on Wed Jun 18, 2025…

Talking Postgres with Claire Giordano

1
Open Source Leadership with Bruce Momjian 1:48:21

לפני 11 weeks1:48:21

1:48:21

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: Open source project website: postgresql.org Website: Bruce Momjian Video of talk: Building Open Source Teams at FOSDEM 2023 Slides: FOSDEM talk on Building Open Source Teams Wikipedia: John C. Maxwell Harry Truman quote: It is amazing what you can accomplish if you do not care who gets the credit The New Stack: How to Generate AI From a Database EDB Blog: Bruce Momjian’s Insights from PGConf India 2025 Conference schedule: PGConf India 2025 Book: Why We Sleep by Matthew Walker Video of talk: Why Database Teams Need Crew Resource Management by Chris Travers Wikipedia: Anna Karenina principle Talking Postgres podcast: Why mentor Postgres developers with Robert Haas Discord invite: PostgreSQL Hacking server Mailing lists: PostgreSQL mailing lists Conference: PostgreSQL Conference Nepal 2025 happening May 5-6 Conference: PostgreSQL Conference Germany 2025 on May 8-9 Conference: POSETTE: An Event for Postgres 2025 on Jun 10-12 Upcoming POSETTE 2025 keynote: Databases in the AI Trenches by Bruce Momjian Conference: SouthEast | LinuxFest on Jun 13-15 in Charlotte NC Conference: Swiss PGDay 2025 happening Jun 26-27 Conference: PGDay Austria 2025 happening in Vienna on Sep 4 Conference: PGDay UK 2025 happening in London on Sep 9 Conference: PGDay Lowlands 2025 happening in Rotterdam on Sep 12 Video from PGConf.dev 2024: Making PostgreSQL Hacking More Inclusive Talking Postgres podcast: How I got started as a developer (& in Postgres) with David Rowley Wikipedia: O'Reilly Open Source Convention (OSCON) Calendar invite: LIVE recording of Ep27 of Talking Postgres to happen on Wed May 07 with guest Peter Farkas. The topic: “How I got started with FerretDB (& why we chose Postgres)”…

Talking Postgres with Claire Giordano

1
Why Python developers just use Postgres with Dawn Wages 1:00:49

לפני 14 weeks1:00:49

1:00:49

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: Project page: psycopg Documentation: Psycopg 3 – PostgreSQL database adapter for Python Project page: PostgreSQL open source project Git repo: code for PostgreSQL.org website Conference: PyCon US 2025, happening May 14-22 in Pittsburgh Conference: PGConf.dev 2025 Schedule , happening May 13-16 in Montreal Canada Conference: Prague PostgreSQL Developer Day 2025 (P2D2) Schedule , which took place Jan 28-29 Wikipedia page: Model-view-controller software design pattern Book: Professional ASP.NET MVC 1.0, affectionately called “the four heads book” Podcast episode: Working in Public with Simon Willison & Marco Slot Blog: Simon Willison’s TILs, aka Things I’ve learned Simon Willison’s Weblog: Here’s how I use LLMs to help me write code Simon Willison’s Weblog: How I make annotated presentations Survey: Python Developers Survey 2023 Results Python Docs: What’s new in Python 3.14 Mentorship program: Djangonaut Space Mentorship program: Media & Talks about Djangonaut Space Podcast episode: Why mentor Postgres developers with Robert Haas Slides: PGConf EU 2024 talk by Claire Giordano about Contributions to Postgres , including maps showing how global the Postgres project is Video of POSETTE 2024 talk by Paolo Melchiorre: Semantic search with Django, PostgreSQL, & pgvector Video of Citus Con 2023 talk: Maps with Django (and PostGIS), by Paolo Melchiorre Video of Citus Con 2022 talk: Django with PostgreSQL superpowers, by Paolo Melchiorre Conference: DjangoCon Africa 2025 , happening August 11-15 in Tanzania Calendar invite: LIVE recording of Ep26 of Talking Postgres to happen on Wed Apr 02, 2025 with guest Bruce Momjian, to talk about Open Source Leadership…

Talking Postgres with Claire Giordano

1
Why mentor Postgres developers with Robert Haas 1:26:23

לפני 19 weeks1:26:23

1:26:23

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: Podcast episode: Becoming a Postgres committer with Melanie Plageman Slide: PGConf EU 2024 talk by Claire Giordano about Contributions to Postgres , including new mentoring program Blog post: New Mentoring Program for Code Contributors in Postgres , by Robert Haas Blog post: Postgres Mentoring Program Updates , by Robert Haas Discord invite for PostgreSQL Hacker Mentoring server: https://discord.gg/bx2G9KWyrY Bio: Margo Seltzer, the PGConf.dev 2024 keynote speaker Video: PGConf.dev 2024 panel discussion about Making PostgreSQL Hacking More Inclusive with Amit Langote, Masahiko Sawada, Melanie Plageman, & Robert Haas Mailing list: PostgreSQL Hackers Upcoming Conference: PGConf.dev 2025, the annual PostgreSQL Development Conference happening in Montreal Canada on May 13-16, 2025 Blog: Postgres committer Tomas Vondra’s Blog - Look for [PATCH IDEA] Video of Talk: CMUDB Database talk about PostgreSQL Optimizer Methodology , by Robert Haas Podcast episode: How I got started as a developer & in Postgres with David Rowley Calendar invite: LIVE recording of Ep25 of Talking Postgres podcast to happen on Wed Mar 12, 2025 with guest Dawn Wages of the Python developer community…

Talking Postgres with Claire Giordano

1
How I got started as a developer & in Postgres with Daniel Gustafsson 1:22:31

לפני 22 weeks1:22:31

1:22:31

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: Wikipedia: ABC 80 Wikipedia: mSQL Wikipedia: PCBoard BBS (bulletin board system) application Conference back in 2010: CHAR(10) – Clustering, HA and Replication Conference Wikipedia: IRIX operating system Internet Archive Wayback Machine link: LinuxForum Conference Agenda from March 5, 2005 with Bruce Momjian’s 3:00pm talk about Postgres Podcast: Solving every data problem in SQL with Dimitri Fontaine & Vik Fearing Conference: Nordic PGDay 2025 to happen Mar 18th in Copenhagen Conference: All Things Open 2025 to happen Oct 12-14 in Raleigh NC Conference: PGConf.dev 2025 to happen May 13-16 in Montreal, Canada CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 9 2025 (it’s a virtual event) Slides from PGConfEU 2024 Talk: What’s in a Postgres major release? An analysis of contributions in v17 timeframe Video of PGConf EU 2024 Talk: Analysis of contributions in the v17 timeframe , by Claire Giordano Book recommendation: The Dragon Book , a.k.a. Compilers: Principles, Techniques, and Tools Book recommendation: The Purple Book (or, Wizard Book), a.k.a. Structure and Interpretation of Computer Programs (SICP) Book recommendation: The Practice of Programming by Kernighan & Pike Calendar invite: LIVE recording of Ep24 of Talking Postgres podcast to happen on Wed Feb 05, 2025 with guest Robert Haas…

Talking Postgres with Claire Giordano

1
Leading engineering for Postgres on Azure with Affan Dar 1:05:52

לפני 28 weeks1:05:52

1:05:52

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: Docs: Azure Database for PostgreSQL – Flexible Server GitHub repo for Durable Task Framework , the first open source project Affan worked on GitHub repo for pgvector open source extension to Postgres Docs: Elastic cluster feature in Azure Database for PostgreSQL – Flexible Server , based on Citus GitHub repo for Citus open source Blog post: Postgres horizontal scaling with elastic clusters on Azure Database for PostgreSQL , by Adam Wølk GitHub repo for DiskANN open source Docs: How to enable and use the DiskANN index for Azure Database for PostgreSQL – Flexible Server Blog post: Think of language models like ChatGPT as a “calculator for words” by Simon Willison Blog post: What’s new with Postgres at Microsoft (updated 2x/year typically) Video of Talk at Microsoft Ignite: Improving accuracy of GenAI apps with Azure Database for PostgreSQL by Maxim Lukiyanov (Microsoft), Jay Yang (UBS), & Orhun Oezbek (UBS) CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 9 2025 Calendar invite: LIVE recording of Ep23 of Talking Postgres podcast to happen on Wed Jan 15, 2025 with guest Daniel Gustafsson…

Talking Postgres with Claire Giordano

1
Helping Rails developers learn Postgres with Andrew Atkinson 1:34:26

לפני 31 weeks1:34:26

1:34:26

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: Book: High Performance PostgreSQL for Rails by Andrew Atkinson E-book Discount: Use discount code TalkingPostgres to get 35% off discount of Andrew’s book Blog post: Readers get their copies of High Performance PostgreSQL for Rails by Andrew Atkinson Book: Swimming to Antarctica: Tales of a Long Distance Swimmer by Lynne Cox Talk Abstract: PGConf NYC 2021 talk by Andrew Atkinson Slides: PGConf NYC 2021 talk on How We Made PG Fitter, Happier, More Productive by Andrew Atkinson Video: POSETTE 2024 talk about SaaS on Rails on PostgreSQL by Andrew Atkinson Ruby User Groups: List of upcoming Ruby user groups Blog post: Writing is Thinking, an annotated twitter thread by Steve Sinofsky Talking Postgres podcast Ep19: Becoming a Postgres committer with Melanie Plageman Talking Postgres podcast Ep20: How I got started as a developer (& in Postgres) with David Rowley CFP: Prague PostgreSQL Developer Day 2025 (P2D2) CFP open until Nov 23, 2024 CFP: FOSDEM PGDay 2025 CFP open until Nov 29, 2024 CFP: Nordic PGDay 2025 CFP open until Dec 31, 2024 CFP: pgDay Paris 2025 CFP open until Dec 31, 2024 CFP: PGConf.dev 2025 CFP open until Jan 01, 2025 CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 09, 2025 Calendar invite: LIVE recording of Ep22 of Talking Postgres podcast…

Talking Postgres with Claire Giordano

1
How I got started as a developer (& in Postgres) with Tom Lane 1:39:18

לפני 36 weeks1:39:18

1:39:18

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: Wikipedia: Tom Lane (computer scientist) Wikipedia: HP 9800 series CMU CS Department Coke Machine history Wikipedia: Honeywell 316 Wikipedia: Teletype Model 33 Wikipedia: Hydra (operating system) Wikipedia: William Wulf Wikipedia: Jon Bentley (computer scientist) Wikipedia: Mary Shaw (computer scientist) Wikipedia: Usenet GitHub: postgres commit by tglsfdc Article: The Mars 2020 Engineering Cameras and Microphone on the Perseverance Rover: A Next-Generation Imaging System for Mars Exploration by J.N. Maki et al. Blog: Open Source on Mars: Community powers NASA’s Ingenuity Helicopter by Klint Finley PostgreSQL Mailing List message: pg_upgrade --check fails to warn about abstime PostgreSQL: Core Team postgresql.git: commitdiff Blog: Proton to Fastmail by Tristan Partin Talking Postgres Ep18: How I got started as a dev (& in Postgres) with David Rowley PGConf EU 2024: Conference Schedule PGConf NYC 2024: Conference Schedule Talking Postgres Ep19: Becoming a Postgres committer with Melanie Plageman PostgreSQL: Commitfests Wikipedia: Cutting room floor PostgreSQL Mailing List message: Straight-from-the-horses-mouth dept PostgreSQL Mailing List message: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges…

Talking Postgres with Claire Giordano

1
Becoming a Postgres committer with Melanie Plageman 1:22:38

לפני 39 weeks1:22:38

1:22:38

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 Pgsql-hackers mailing list: Announcement about new Postgres committers Conference: PGConf.dev 2025 Blog: Talk, then code by Dave Cheny Blog posts about mentoring by Robert Haas Blog: Mentoring Program Updates by Robert Haas X: Brendan Burn’s tweet about the Kubernetes Chop Wood and Carry Water award Award: Chop Wood Carry Water Blog: Who Contributed to PostgreSQL Development in 2023? by Robert Haas Abstract: What's in a Postgres major release? An analysis of contributions in the v17 timeframe for PGConfEU 2024 by Claire Giordano Talking Postgres Ep18: How I got started as a developer (& in Postgres) with David Rowley Wikipedia: PostgreSQL Contributor Gifts Cal invite for next Ep 20 of Talking Postgres with Tom Lane to be recorded LIVE on Wed Oct 9, 2024 Podcasts & conference videos that Melanie listens to when running that she recommends to Postgres developers: Podcast: Oxide and Friends Podcast: postgres.fm Podcast: Software Engineering Radio Podcast: Talking Postgres with Claire Giordano Podcast: Two’s Complement SE Radio: Ep 432: Brian D Foy on Perl 7 Video: Memory & Caches by Matt Godbolt Videos: POSETTE 2024 playlist Video: RailsConf 2014 - All the Little Things by Sandi Metz YouTube: Brandon Foltz YouTube: CMU Database Group YouTube: Kernel Recipes YouTube: Linux Plumbers Conference YouTube: Matt Godbolt YouTube: Onur Mutlu Lectures YouTube: pganalyze YouTube: PostgreSQL Development Conference YouTube: SNIAVideo YouTube: Strange Loop Conference YouTube: The Linux Foundation…

Talking Postgres with Claire Giordano

1
How I got started as a developer (& in Postgres) with David Rowley 1:29:08

לפני 45 weeks1:29:08

1:29:08

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: Wikipedia: Acorn Computers PostgreSQL Mailing List Archives: David’s first email: Possible problem with EXTRACT(EPOCH FROM TIMESTAMP) Google Usenet: Larry Page’s Java question from Jan 7, 1996 Blog: Speeding up sort performance in Postgres 15 by David Rowley Blog: What’s new in the Postgres 16 query planner / optimizer by David Rowley Book: The Art of PostgreSQL by Dimitri Fontaine Book: The Art of SQL by Stéphane Faroult, Peter Robson Book: The Art of Writing Efficient Programs: An advanced programmer's guide to efficient hardware utilization and compiler optimizations using C++ examples by Fedor G. Pikus X: Simon Willison’s tweet Blog by Tony Finch Book: Daily Rituals: How Artists Work by Mason Currey GitHub Issue: Coughing in my microphone causes segfault PostgreSQL Mailing Lists: Overview PostgreSQL Mailing Lists: pgsql-general PostgreSQL Mailing Lists: pgsql-hackers Video: Making your patch more committable by Melanie Plageman at PGConf.EU 2023 Cheese company: Seriously Cheddar Talking Postgres Ep04: How I got started as a dev and in Postgres with Melanie Plageman & Thomas Munro Talking Postgres Ep08: How I got started as a developer (& in Postgres) with Andres Freund & Heikki Linnakangas Cal invite for next Ep19 of Talking Postgres with Melanie Plageman Cal invite for next Ep 20 of Talking Postgres with Tom Lane…

Talking Postgres with Claire Giordano

1
Podcasting about Postgres with Pino de Candia 1:24:09

לפני 49 weeks1:24:09

1:24:09

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: Cal invite for next Ep18 of Talking Postgres with David Rowley Podcast: Talking Postgres Talking Postgres Ep01: Working in public on open source with Simon Willison & Marco Slot Ep02: How to get Postgres ready for the next 100 million users Ep03: Why giving talks at Postgres conferences matters with Álvaro Herrera and Boriss Mejías Video: Postgres Storytelling: What’s going on with Synchronous Replication | POSETTE 2024 by Boriss Mejías Video: Postgres Storytelling: Support in the Darkest Hour | Citus Con 2023, by Boriss Mejías Ep04: How I got started as a dev and in Postgres with Melanie Plageman & Thomas Munro Ep05: My favorite ways to learn more about PostgreSQL with Grant Fritchey & Ryan Booz Video: Fibonacci Spirals and Ways to Contribute to Postgres —Beyond Code | Citus Con 2022, by Claire Giordano Ep06: You're probably already using Postgres with Chelsea Dole & Floor Drees Wikipedia: Object–relational mapping Video: How to work with other people | POSETTE 2024, by Floor Drees and Jimmy Angelakos Ep07: Why people care about PostGIS and Postgres with Paul Ramsey & Regina Obe Ep08: How I got started as a developer (& in Postgres) with Andres Freund & Heikki Linnakangas Satya Nadella’s LinkedIn post about Andres Freund’s xz backdoor discovery Ep09: Solving every data problem in SQL with Dimitri Fontaine & Vik Fearing Wikipedia: Advent of Code Ep10: My Journey into Postgres Monitoring with Lukas Fittl & Rob Treat Ep11: My Journey into Performance Benchmarking with Jelte Fennema-Nio & Marco Slot Ep12: From developer to PostgreSQL specialist with Derk van Veen Ep13: Spinning up on Postgres & AI with Arda Aytekin Ep14: Becoming expert at using PostgreSQL with Chris Ellis Video: Electric Elephants | pgDay Paris 2024, by Chris Ellis Ep15: My Journey to Explaining Explain with Michael Christofides Podcast: Postgres FM Ep16: The Making of POSETTE: An Event for Postgres with Teresa Giacomini & Aaron Wislang Podcast: Scaling PostgreSQL Podcast: Postgres FM Ep99 with guest Claire Giordano: Sponsoring the community Podcast: Hacking Postgres Playlist: 5mins of Postgres…

Talking Postgres with Claire Giordano

1
The Making of POSETTE: An Event for Postgres with Teresa Giacomini & Aaron Wislang 1:35:04

לפני 52 weeks1:35:04

1:35:04

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: Blog post: What’s in a name? About the naming of POSETTE: An Event for Postgres FOSDEM : the conference whose name inspired the POSETTE name Playlist of all 42 talks from POSETTE : An Event for Postgres 2024 Playlist of the 4 unique livestreams from POSETTE 2024 CFP is open: PGDay Lowlands 2024 Call for Papers will close July 9, 2024 Virtual conference that POSETTE organizers were inspired by: P99 Conf Discord: Microsoft Open Source Discord , Home for virtual hallway track for #posetteconf Adam Wølk’s speaker page for POSETTE Speaker interview with Polina Bungina at POSETTE Blog post: About Talk Selection for POSETTE: An Event for Postgres 2024 , by Claire Giordano Blog post: Building the PGConf.dev Programme , by Paul Ramsey pgDay Paris 2024 note about talk selection process Keynote: All The Postgres Things at Microsoft, POSETTE edition , by Charles Feddersen Keynote: The Open Source Geospatial Community, PostGIS, & Postgres , by Regina Obe Keynote: Why I love open source development & what I learned from K8s , by Sarah Novotny Keynote: A Walking Tour of PostgreSQL , by Thomas Munro Lyrics from The Perfect Space by The Avett Brothers Video: Lessons Learned benchmarking & profiling distributed PostgreSQL , by Lotte Felius Video: Postgres Storytelling: Support in the Darkest Hour | Citus Con 2023 , by Boriss Mejías Video: Postgres Storytelling: What's going on with Synchronous Replication? , by Boriss Mejías Video: Vindicating ZFS with PostgreSQL: Unleashing the Power of Scalability , includes a bit of jazz music by Federico Campoli Blog post: Ultimate Guide to POSETTE: An Event for Postgres, 2024 edition Social post: Tweet by Kelsey Hightower with advice to conference organizers Video from PGConfEU 2023: So you want a PGDay in your city , by Henrietta Dombrovskaya & Teresa Giacomini Blog post: The Story Behind the Activity Book for Postgres , by Teresa Giacomini…

Talking Postgres with Claire Giordano

1
My Journey to Explaining Explain with Michael Christofides 1:25:43

לפני 1 year1:25:43

1:25:43

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: Schedule for POSETTE: An Event for Postgres 2024 Michael Christofides' company, pgMustard Blog: Where our name came from by Michael Christofides Wiki: Using EXPLAIN X: Nikolay Samokhvalov Video: Lightning Talks at pgDay Paris 2024 Blog: What’s new with Postgres at Microsoft (August 2023) by Claire Giordano Blog: Faster PostgreSQL Counting by Joe Nelson GitHub: pg_docs_bot (browser extension) GitHub Docs: About GitHub Copilot Chat Documentation: Using EXPLAIN Glossary: EXPLAIN Glossary by Michael Christofides Video: EXPLAIN Explained by Josh Berkus Blog: Reading a Postgres EXPLAIN ANALYZE Query Plan by Caleb Hearth Blog: Explaining the unexplainable by Depesz PostgreSQL execution plan visualizer, explain.dalibo.com Blog: Planet PostgreSQL News: Postgres Weekly Playlist: 5mins of Postgres Podcast: Postgres FM podcast Cal invite for next Ep16 of Path To Citus Con podcast with Aaron Wislang & Teresa Giacomini…

Talking Postgres with Claire Giordano

1
Becoming expert at using PostgreSQL with Chris Ellis 1:09:46

לפני 1 year1:09:46

1:09:46

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: Chris's first thread on the PostgreSQL mailing lists Slides: IoT with PostgreSQL —by Chris Ellis at PGConf.EU 2023 Slides: Advantage PostgreSQL —by Chris Ellis at Nordic PGDay 2024 Video: Should I use JSON in PostgreSQL? —by Boriss Mejías at PGConf.EU 2023 Slides: Fighting the Butterflies & giving your first Postgres conference talk —by Claire Giordano at pgDay Paris 2024 Markus Winand's website, Modern SQL Wikipedia: Linus’s law Andres Freund’s xz backdoor discovery Andres Freund’s Mastodon Toot about xz backdoor Podcast: Path to Citus Con Ep08: How I got started as a developer (& in Postgres) with Andres Freund & Heikki Linnakangas Podcast: Path To Citus Con Ep11: My Journey into Performance Benchmarking with Jelte Fennema-Nio & Marco Slot Podcast: Oxide and Friends next episode on Mon Apr 08 2024, featuring Andres Freund from Microsoft Jessie Frazelle tweet on LLM Video of pgDay Paris 2024 lightning talks, including Chris's "Electric Elephants" talk Post about Simon Riggs's tragic passing last week . He will be missed, he is missed, and many are heartbroken Simon Riggs: The Next 20 Years —keynote at PGConf.EU 2023 Book: The Art of PostgreSQL by Dimitri Fontaine Podcast: Path To Citus Con Ep09: Solving every data problem in SQL w/Dimitri Fontaine & Vik Fearing Blog: Planet PostgreSQL Blog: Contributing to Postgres 101: A Beginner's Experience by Elizabeth Christensen Book: Linux Kernel Development by Robert Love Chris Ellis’s LED PCB Art Blog: pgDay Paris – Postgres Community, cheese and wine by Boriss Mejías Podcast: LUG Radio CFP for POSETTE: An Event for Postgres (free & virtual event) open until Sunday April 7th 2024 at 11:59pm PDT Cal invite for next Ep15 of Path To Citus Con podcast with Michael Christofides…

Talking Postgres with Claire Giordano

1
Spinning up on Postgres & AI with Arda Aytekin 1:18:33

לפני 1 year1:18:33

1:18:33

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: pgvector on GitHub: https://github.com/pgvector/pgvector Andrew Kane: https://github.com/ankane Simon Willison’s Blog: https://simonwillison.net/ Demo of Azure AI & pgvector with Azure Database for PostgreSQL by Claire Giordano: https://youtu.be/em0PKDGzzlQ?si=TrOQHXO5gqIuGsU0 Blog: Introducing the azure_ai extension to Azure Database for PostgreSQL by Denzil Ribeiro: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/introducing-the-azure-ai-extension-to-azure-database-for/ba-p/3980291 Documentation: Azure Database for PostgreSQL - Flexible Server Azure AI Extension: https://learn.microsoft.com/azure/postgresql/flexible-server/generative-ai-azure-overview Blog: Vectors are the new JSON in PostgreSQL by Jonathan Katz: https://jkatz05.com/post/postgres/vectors-json-postgresql/ Responsible AI at Microsoft: https://aka.ms/rai Andreessen's Corollary: Ethical Dilemmas in Software Engineering by Bryan Cantrill: https://www.youtube.com/watch?v=0wtvQZijPzg Blog: Phi-2: The surprising power of small language models by Mojan Javaheripi & Sébastien Bubeck: https://www.microsoft.com/research/blog/phi-2-the-surprising-power-of-small-language-models/ pg_vectorize: https://github.com/tembo-io/pg_vectorize OpenAI API documentation: https://platform.openai.com/docs/introduction Microsoft Azure AI Fundamentals: Generative AI - Training: https://learn.microsoft.com/training/paths/introduction-generative-ai/ ChatGPT Prompt Engineering for Developers: https://www.deeplearning.ai/short-courses/chatgpt-prompt-engineering-for-developers/ Andrej Karpathy's keynote @ Microsoft Build 2023: https://www.youtube.com/watch?v=bZQun8Y4L2A Stanford University CS231n: Deep Learning for Computer Vision: http://cs231n.stanford.edu/ LangChain: https://www.langchain.com/ Towards Data Science: https://towardsdatascience.com/ Generative AI for Beginners on GitHub: https://github.com/microsoft/generative-ai-for-beginners/ Zero-shot learning: https://en.wikipedia.org/wiki/Zero-shot_learning Andrej Karpathy thread on LLMs: https://www.threads.net/@karpathy/post/C3lBSlov1QJ/ Podcast: Path to Citus Con Ep01: Working in public on open source with Simon Willison & Marco Slot: https://talkingpostgres.com/episodes/working-in-public-on-open-source The Art of PostgreSQL by Dimitri Fontaine, get 15% OFF with CLAIRE15: https://theartofpostgresql.com/ Podcast: Path to Citus Con Ep08: Solving every data problem in SQL w/Dimitri Fontaine & Vik Fearing: https://talkingpostgres.com/episodes/solving-every-data-problem-in-sql-w-dimitri-fontaine-vik-fearing ) Arda Aytekin’s scheduled talk at PGDay Chicago 2024 on April 26: https://postgresql.us/events/pgdaychicago2024/schedule/session/1542-learnings-from-extension-development-in-rust-pgrx/ CFP for POSETTE: An Event for Postgres (free & virtual event) open until April 7th 2024: https://aka.ms/posette-cfp-2024…

Talking Postgres with Claire Giordano

1
From developer to PostgreSQL specialist with Derk van Veen 1:11:16

לפני 1 year1:11:16

1:11:16

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: Explaining the PostgreSQL concurrency control mechanisms by Derk van Veen: https://www.youtube.com/watch?v=SkxwaN46K88 Podcast: Path to Citus Con Ep03: Why give talks at Postgres conferences with Álvaro Herrera & Boriss Mejías: https://talkingpostgres.com/episodes/why-giving-talks-at-postgres-conferences-matters Blog: A Deep Dive into Table Partitioning part 3 by Derk van Veen & Cosmin Octavian Pene: https://www.adyen.com/knowledge-hub/maintenance-under-pressure Book: On Writing: A Memoir of the Craft by Stephen King: https://stephenking.com/works/nonfiction/on-writing-a-memoir-of-the-craft.html PechaKucha, 20 slides for 20 seconds: https://en.wikipedia.org/wiki/PechaKucha pgChess: PostgreSQL 9.1+ extension for the game of Chess on GitHub: https://github.com/gciolli/pgChess FOSDEM PGDay 2023 talk by Derk van Veen: Fighting Write Amplification By Stimulating Hot Updates Through The Fill Factor: https://www.postgresql.eu/events/fosdem2023/schedule/session/4196-fighting-write-amplification-by-stimulating-hot-updates-through-the-fill-factor/ Blog: Fighting PostgreSQL write amplification with HOT updates by Derk van Veen & Dave Pitts: https://www.adyen.com/knowledge-hub/postgresql-hot-updates FOSDEM PGDay 2024 talk by Derk van Veen & Boriss Mejías: High Available Configurations Are Very Common For Postgresql. But How Do You Investigate Performance Problems When The Standby Can't Keep Up? https://www.postgresql.eu/events/fosdem2024/schedule/session/5164-high-available-configurations-are-very-common-for-postgresql-but-how-do-you-investigate-performance-problems-when-the-standby-cant-keep-up/ FOSDEM PGDay 2024 slides by Derk van Veen & Boriss Mejías: High Available Configurations Are Very Common For Postgresql. But How Do You Investigate Performance Problems When The Standby Can't Keep Up? https://www.postgresql.eu/events/fosdem2024/sessions/session/5164/slides/460/HA_delay_analysis.pdf X post with picture about Derk and Boriss’ talk on FOSDEM PGDay 2024 by Devrim Gündüz: https://twitter.com/DevrimGunduz/status/1753348159026130959?s=20 Blitz Chess game: https://www.chess.com/terms/blitz-chess CFP for POSETTE: An Event for Postgres (free & virtual event) open until April 7th 2024: https://aka.ms/posette-cfp-2024…

Talking Postgres with Claire Giordano

1
My Journey into Performance Benchmarking with Jelte Fennema-Nio & Marco Slot 1:13:35

לפני 1 year1:13:35

1:13:35

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: Podcast: Path To Citus Con Ep01: Working in public on open source with Simon Willison & Marco Slot: https://talkingpostgres.com/episodes/working-in-public-on-open-source Streetlight effect: https://en.wikipedia.org/wiki/Streetlight_effect BenchBase: https://db.cs.cmu.edu/projects/benchbase/ HammerDB: https://www.hammerdb.com/ Slides: Intro to benchmarking with pgbench at PGConf NYC 2023 by Melanie Plageman: https://speakerdeck.com/melanieplageman/intro-to-benchmarking-with-pgbench Locust: https://locust.io/ Blog post: How to benchmark performance of Citus and Postgres with HammerDB on Azure by Jelte Fennema-Nio: https://www.citusdata.com/blog/2022/03/12/how-to-benchmark-performance-of-citus-and-postgres-with-hammerdb/ Profiling with perf: https://wiki.postgresql.org/wiki/Profiling_with_perf Flame Graphs: https://www.brendangregg.com/flamegraphs.html Brendan Gregg’s Website, a super-valuable resource for performance engineering: https://www.brendangregg.com/overview.html Video: Analyzing Postgres performance problems using perf and eBPF by Andres Freund: https://www.youtube.com/watch?v=HghP4D72Noc Video: Explanatory talk about compiler optimization and memory & caches by Matt Godbolt: https://www.youtube.com/watch?v=4_smHyqgDTU&t=52s Compiler Explorer is fantastic, especially if you want to know how different compilers will optimize your code: https://godbolt.org/ Mark Callaghan Twitter account @MarkCallaghanDB: https://twitter.com/MarkCallaghanDB PGConf.dev CFP is open until Mon Jan 15 2024 at 11:59pm PST: https://2024.pgconf.dev/cfp/ 3rd party performance benchmark in 2023 by GigaOM on Transaction Processing & Price-Performance Testing of Distributed SQL Databases: https://gigaom.com/report/transaction-processing-price-performance-testing/ Blog post: "Query from any node" feature for Citus, by Marco Slot: https://www.citusdata.com/blog/2022/06/17/citus-11-goes-fully-open-source/…

Talking Postgres with Claire Giordano

1
My Journey into Postgres Monitoring with Lukas Fittl & Rob Treat 1:21:02

לפני 2 years1:21:02

1:21:02

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: OpenTelemetry: https://opentelemetry.io/ pganalyze: https://pganalyze.com/ pgDash: https://pgdash.io/ pgMustard: https://www.pgmustard.com/ pg_stat_statements docs: https://www.postgresql.org/docs/current/pgstatstatements.html pg_hint_plan: https://github.com/ossc-db/pg_hint_plan pg_hint_plan hint list: https://github.com/ossc-db/pg_hint_plan/blob/master/docs/hint_list.md Example for PostgreSQL with pg_hint_plan: https://api.rubyonrails.org/classes/ActiveRecord/QueryMethods.html#method-i-optimizer_hints 5mins of Postgres by pganalyze: https://www.youtube.com/playlist?list=PLhqxwIAgz78HZhWyu3UyKrCWNk7VWjVpj Monitoring page on PostgreSQL wiki: https://wiki.postgresql.org/wiki/Monitoring PgHero GitHub repo: https://github.com/ankane/pghero Insights on pgBadger: A PGSQL Phriday #010 Recap: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/community-insights-on-pgbadger-a-pgsql-phriday-010-recap/ba-p/3880911 Get PostgreSQL Logs Into Honeycomb: https://docs.honeycomb.io/getting-data-in/logs/postgresql/ Blog post by Lukas Fittl about pg_stat_io by Lukas: https://pganalyze.com/blog/pg-stat-io Blog post by Andrew Atkinson about pg_stat_io: https://andyatkinson.com/blog/2023/11/01/PostgreSQL-IO-Visibility-wehack-pg_stat_io BPFtrace by iovisor GitHub repo: https://github.com/iovisor/bpftrace Trace PostgreSQL locks with pg_lock_tracer: https://jnidzwetzki.github.io/2023/01/11/trace-postgresql-locks-with-pg-lock-tracer.html sysdig by draios GitHub repo: https://github.com/draios/sysdig Using BPFtrace to trace PostgreSQL vacuum operations: https://www.timescale.com/blog/using-bpftrace-to-trace-postgresql-vacuum-operations/ PostgreSQL Mailing Lists: https://www.postgresql.org/list/ psql — PostgreSQL interactive terminal: https://www.postgresql.org/docs/current/app-psql.html Ongoing discussion thread about pg_stat_statements: https://commitfest.postgresql.org/46/2837/ Reconnoiter project referenced by Rob: https://github.com/circonus-labs/reconnoiter/tree/master/sql Funny tweet about PostgreSQL pronunciation: https://twitter.com/as_w/status/1648373353214885892 O11ycast EP63 with Lukas Fittl: https://www.heavybit.com/library/podcasts/o11ycast/ep-63-observability-in-the-database-with-lukas-fittl-of-pganalyze Oxide and Friends podcast: https://oxide-and-friends.transistor.fm/…

Talking Postgres with Claire Giordano

1
Solving every data problem in SQL w/Dimitri Fontaine & Vik Fearing 1:17:06

לפני 2 years1:17:06

1:17:06

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: Dimitri Fontaine’s blog: https://tapoueh.org/ Advent of Code: https://adventofcode.com/ Dimitri’s book, The Art of PostgreSQL: https://theartofpostgresql.com/ Blog post about What’s new in SQL:2023: https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new PostgreSQL Exercises at pgexercises.com: https://pgexercises.com/ SQL Murder Mystery for learning SQL: https://mystery.knightlab.com/ Pgvector extension for Postgres and AI embeddings: https://github.com/pgvector/pgvector Vik’s Advent of Code puzzle solutions in SQL on GitHub: https://github.com/xocolatl/advent-of-code Stack Overflow data in Postgres, from pgtreats GitHub repo: https://github.com/pgtreats/stackoverflow_in_pg OpenStreetMap runs on Postgres: https://www.openstreetmap.org/#map=4/38.01/-95.84 Uber data set: https://github.com/fivethirtyeight/uber-tlc-foil-response Ideas for fun, open data sets: https://data.world/data-society?entryTypeLabel=dataset&tab=resources “Don’t Do This” Timestamp learnings on PostgreSQL wiki: https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_timestamp_.28without_time_zone.29…

Talking Postgres with Claire Giordano

1
How I got started as a developer (& in Postgres) with Andres Freund & Heikki Linnakangas 1:13:25

לפני 2 years1:13:25

1:13:25

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: Neon: https://neon.tech/ Rob Conery and Scott Hanselman's book: The Imposter's Handbook ( https://twitter.com/shanselman/status/1610805353255677953 ) Path To Citus Con Ep04: https://talkingpostgres.com/episodes/how-i-got-started-as-a-developer-in-postgres Andres’ first patch to Postgres: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c43feefa806c81d68115ed03a7f723720cefad31 PGConf NYC 2023: https://2023.pgconf.nyc/ Flow book: https://www.google.com/books/edition/Flow/QVjPsd1UukEC Archives of Postgres hackers mailing list: https://www.postgresql.org/list/pgsql-hackers/ List of Postgres Contributors: https://www.postgresql.org/community/contributors/ Description of Postgres Core Team: https://www.postgresql.org/developer/core/ Postgres Weekly newsletter: https://postgresweekly.com/…

Talking Postgres with Claire Giordano

1
Why people care about PostGIS and Postgres with Paul Ramsey & Regina Obe 1:10:10

לפני 2 years1:10:10

1:10:10

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: PostGIS: https://postgis.net/ FOSS4G NA: https://foss4gna.org/ Ushahidi: https://www.ushahidi.com/ Humanitarian Open Street Map: https://www.hotosm.org/ OpenStreetMap: https://www.openstreetmap.org/ pgRouting: https://pgrouting.org/ Regina Obe’s books: https://locatepress.com/book/pgr Regina’s book “PostGIS In Action”: https://www.manning.com/books/postgis-in-action-third-edition?experiment=B MobilityDB: https://github.com/MobilityDB/MobilityDB Blog: Analyzing GPS trajectories at scale with Postgres, PostGIS, MobilityDB, & Citus: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/analyzing-gps-trajectories-at-scale-with-postgres-mobilitydb-amp/ba-p/1859278 OSGeo: https://www.osgeo.org/ Simon Willison’s presentation on "The weird world of LLMs": https://simonwillison.net/2023/Aug/3/weird-world-of-llms/ QGIS: https://qgis.org/en/site/ QGIS “Gentle Introduction” documentation: https://docs.qgis.org/3.28/en/docs/gentle_gis_introduction/ PostGIS Workshops: https://postgis.net/documentation/training/#workshop Locate Press: https://locatepress.com/ FedGeoDay 2023: https://www.fedgeo.us/about-2023 Schedule of FOSS4G NA 2023: https://foss4gna.org/schedule.html#schedule FOSS4G Brazil, December 2024: https://www.osgeo.org/foundation-news/foss4g-2024-has-been-awarded-to-belem-brazil/ Paul's keynote talk at PGConfEU in Lisbon in 2018, titled "Put some "where" in your WHERE clause": https://docs.google.com/presentation/d/1xyXA4-0wmNX7WfiLeH9h10bIkZxrej278-mMaClagys/edit?usp=sharing…

Talking Postgres with Claire Giordano

1
You're probably already using Postgres: What you need to know with Chelsea Dole & Floor Drees 1:10:01

לפני 2 years1:10:01

1:10:01

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: Fintech startup where Chelsea works, Brex: https://www.brex.com/ Open source data platform where Floor works, Aiven: https://aiven.io/ “Mission-Critical PostgreSQL Databases on Kubernetes" by Karen Jex at KubeCon Europe 2023: https://www.youtube.com/watch?v=_NBQ9JmOMko The Imposters Handbook by Rob Conery: https://bigmachine.io/products/the-imposters-handbook/ Designing Data-Intensive Applications by Martin Kleppmann: https://www.oreilly.com/library/view/designing-data-intensive-applications/9781491903063/ Devopsdays Amsterdam: https://devopsdays.org/events/2023-amsterdam/welcome/ Building Community in Open Source with Floor Drees on the Last Week in AWS podcast: https://www.lastweekinaws.com/podcast/screaming-in-the-cloud/building-community-in-open-source-with-floor-drees/ pg_stat_statements: https://www.postgresql.org/docs/current/pgstatstatements.html PostGIS: https://postgis.net/ “Postgres tips for optimizing Django & Python performance, from my PyCon workshop” by Louise Grandjonc: https://www.citusdata.com/blog/2020/05/20/postgres-tips-for-django-and-python/ Video of Louise’s PyCon talk, Optimize Django & Python performance with Postgres superpowers: https://youtu.be/dyBLGjCQJHs Grafana: https://grafana.com/ pganalyze: https://pganalyze.com/ auto_explain: https://www.postgresql.org/docs/current/auto-explain.html EXPLAIN ANALYZE in PostgreSQL: https://www.postgresql.org/docs/current/sql-explain.html psql: https://www.postgresguide.com/utilities/psql/ Path To Citus Con Episode 05: My favorite ways to learn more about PostgreSQL with Grant Fritchey and Ryan Booz: https://talkingpostgres.com/episodes/my-favorite-ways-to-learn-more-about-postgresql-with-grant-fritchey-and-ryan-booz Coffee Meets Bagel (dating app): https://coffeemeetsbagel.com/…

Talking Postgres with Claire Giordano

1
My favorite ways to learn more about PostgreSQL with Grant Fritchey & Ryan Booz 1:18:03

לפני 2 years1:18:03

1:18:03

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: Talk: Ryan’s talk Point-in-time query tuning and observability with pg_stat_statements at Citus Con: An Event for Postgres 2022 Blog: Learning PostgreSQL with Grant , a series for SQL Server devs learning about Postgres Podcast: postgres.fm, a weekly podcast about all things Postgres Podcast: Path To Citus Con Episode 01: Working in public on open source Blog aggregator: Planet PostgreSQL Email Newsletters: Cooperpress, including the Postgres Weekly email Podcast: Scaling PostgreSQL with Creston Jamison User Groups: PostgreSQL Community User Groups Videos: pganalyze "5 minutes of Postgres," by Lukas Fittl Book: The Art of PostgreSQL, by Dimitri Fontaine Book: PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, by Henrietta Dombrovskaya Book: SQL Performance Explained, by Markus Winand Blog: Modern SQL, by Markus Winand Blog: Use The Index, Luke, by Markus Winand Book: Database Administration, by Craig Mullins Book: A Curious Moon, by Rob Conery Book: The Little SQL Book, by Rob Conery , “Learn SQL While Watching Football This Weekend - Free!” Event: PGDay Chicago Blog: Redgate – Simple Talk Videos: CMU Database Group’s Talks on YouTube: Quarantine (2020) , First Dose (2021) , Second Dose (2021) , Booster (2022) Crunchy Data’s Postgres Playground Blog: CYBERTEC Blog: Citus Open Source Blog Talk: How To Make Your Postgres Blog Posts Reach A Ton More People, by Claire Giordano Conference: PGCon 2023 , super useful to watch recorded talks after the fact Conference: PGConf.EU, 2022 , good example of an in-person event with lots of opportunities for learning Conference: Citus Con: An Event for Postgres 2023 Conference: PGConf NYC 2023 Blog Series: PGSQL Phriday , created by Ryan Booz Blog Series: PostgreSQL Person of the Week, by Andreas Scherbaum Blog: Robert Haas' blog Blog: select * from depesz; Book: PostgreSQL 14 internals, by Egor Rogov…

Talking Postgres with Claire Giordano

1
How I got started as a dev and in Postgres with Melanie Plageman & Thomas Munro 1:17:26

לפני 2 years1:17:26

1:17:26

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: Parallelism in PostgreSQL 15: Thomas’ Citus Con talk Additional IO Observability in Postgres with pg_stat_io: Melanie’s Citus Con talk Visualizing PostgreSQL I/O Performance for Development : Melanie’s talk at PGCon 2023 Add pg_stat_io view, providing more detailed IO statistics, committed by Melanie Plageman in PG 16 Neil deGrasse Tyson’s podcast StarTalk From Nand to Tetris by Noam Nisan and Shimon Schocken Sinclair ZX81 All Things Open conference PostgreSQL BuildFarm Queues in PostgreSQL: Thomas’ 2022 talk…

Talking Postgres with Claire Giordano

1
Why give talks at Postgres conferences with Álvaro Herrera & Boriss Mejías 1:04:46

לפני 2 years1:04:46

1:04:46

Á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: Postgres Storytelling: Support in the Darkest Hour : Boriss’ Citus Con talk A Curious Moon book by Rob Conery Tomas Vondra's talks on YouTube pgDay Paris 2022 FOSDEM PostgreSQL devroom FOSDEM PGDAY 2023 Nordic PGDay 2022 PGConf.EU 2022 LFMF: How a CREATE INDEX CONCURRENTLY led to a 6 hour downtime by Gunnar "Nick" Bluth…

Talking Postgres with Claire Giordano

1
How to get Postgres ready for the next 100 million users 1:01:30

לפני 2 years1:01:30

1:01:30

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: Additional IO Observability in Postgres : Melanie's talk at Citus Con 2023 Optimizing Postgres for write heavy workloads ft. Checkpoint and WAL configs : Samay's talk at Citus Con 2023 The Design of Postgres , by Michael Stonebraker and Lawrence A. Rowe, 1986 HyperLogLog PostGIS timescale/pgspot…

Talking Postgres with Claire Giordano

1
Working in public on open source with Simon Willison & Marco Slot 1:05:02

לפני 2 years1:05:02

1:05:02

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: Simon's weeknotes Simon's TIL posts Datasette plugins Citus open source GitHub repo Fibonacci Spirals and Ways to Contribute to Postgres—Beyond Code - Claire's talk in 2022 Big Opportunities in Small Data - Simon's keynote at Citus Con: An Event for Postgres The Distributed PostgreSQL Problem and How Citus Solves It - Marco’s keynote at Citus Con: An Event for Postgres…

ברוכים הבאים אל Player FM!

Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.

תקשיבו ל-500+ נושאים

דומה לTalking Postgres with Claire Giordano

Amazon eGift Card - Amazon Logo (Animated)

The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking About

Bounty Paper Towels Quick Size, White, 16 Family Rolls = 40 Regular Rolls (Packaging May Vary)

פודקאסטים ששווה להאזין

Talking Postgres with Claire Giordano « » Leading engineering for Postgres on Azure with Affan Dar

Leading engineering for Postgres on Azure with Affan Dar

פודקאסטים ששווה להאזין

ברוכים הבאים אל Player FM!

The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking About

The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking About

TurboTax Deluxe 2024 Tax Software, Federal & State Tax Return [PC/MAC Download]

Amazon eGift Card - Bright Balloons (Animated)

The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking About

דומה לTalking Postgres with Claire Giordano

מדריך עזר מהיר

Talking Postgres with Claire Giordano « »
Leading engineering for Postgres on Azure with Affan Dar