My Journey to Explaining Explain with Michael Christofides | Path To Citus Con Ep15

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.
* 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: talkingpostgres.com
Chapters:
⏩ 1:50 First encounter with Postgres
⏩ 24:50 Why is the name pgMustard?
⏩ 28:20 Explain EXPLAIN
⏩ 37:15 Michael’s opinions on BUFFERS
⏩ 47:22 New world within Postgres
⏩ 1:01:21 Postgres documentation
⏩ 1:14:16 Fave Postgres resources
📜 Full transcript of this podcast episode available at:
pathtocituscon.transistor.fm/...
✅ Listen to more episodes of Path To Citus Con:
aka.ms/PathToCitusCon
📅 Subscribe to the monthly Path To Citus Con calendar:
aka.ms/PathToCitusCon-cal
Links mentioned in this episode:
🔹Schedule for POSETTE: An Event for Postgres 2024: aka.ms/posette-schedule
🔹Michael Christofides' company, pgMustard: www.pgmustard.com/
🔹Blog: Where our name came from by Michael Christofides: www.pgmustard.com/blog/thats-...
🔹Wiki: Using EXPLAIN: wiki.postgresql.org/wiki/Usin...
🔹X: Nikolay Samokhvalov: / samokhvalov
🔹Video: Lightning Talks at pgDay Paris 2024: • Lightning talks
🔹Blog: What’s new with Postgres at Microsoft (August 2023) by Claire Giordano: techcommunity.microsoft.com/t...
🔹Blog: Faster PostgreSQL Counting by Joe Nelson: www.citusdata.com/blog/2016/1...
🔹GitHub: pg_docs_bot (browser extension): github.com/mchristofides/pg_d...
🔹GitHub Docs: About GitHub Copilot Chat: docs.github.com/en/copilot/gi...
🔹Documentation: Using EXPLAIN: www.postgresql.org/docs/curre...
🔹Glossary: EXPLAIN Glossary by Michael Christofides: www.pgmustard.com/docs/explain
🔹Video: EXPLAIN Explained by Josh Berkus: • EXPLAIN Explained
🔹Blog: Reading a Postgres EXPLAIN ANALYZE Query Plan by Caleb Hearth: thoughtbot.com/blog/reading-a...
🔹Blog: Explaining the unexplainable by Depesz: www.depesz.com/2013/04/16/exp...
🔹PostgreSQL execution plan visualizer: explain.dalibo.com/
🔹Blog: Planet PostgreSQL: planet.postgresql.org/
🔹News: Postgres Weekly: postgresweekly.com/
🔹Playlist: 5mins of Postgres: • 5mins of Postgres
🔹Podcast: Postgres FM podcast: postgres.fm/
🔹Cal invite for next Ep16 of Path To Citus Con podcast with Aaron Wislang & Teresa Giacomini: aka.ms/pathToCitusCon-Ep16-cal
#PathToCitusCon #TalkingPostgres #PostgreSQL