POPULARITY
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.orgWebsite: Bruce MomjianVideo of talk: Building Open Source Teams at FOSDEM 2023Slides: FOSDEM talk on Building Open Source TeamsWikipedia: John C. MaxwellHarry Truman quote: It is amazing what you can accomplish if you do not care who gets the creditThe New Stack: How to Generate AI From a DatabaseEDB Blog: Bruce Momjian's Insights from PGConf India 2025Conference schedule: PGConf India 2025Book: Why We Sleep by Matthew WalkerVideo of talk: Why Database Teams Need Crew Resource Management by Chris TraversWikipedia: Anna Karenina principleTalking Postgres podcast: Why mentor Postgres developers with Robert HaasDiscord invite: PostgreSQL Hacking serverMailing lists: PostgreSQL mailing listsConference: PostgreSQL Conference Nepal 2025 happening May 5-6Conference: PostgreSQL Conference Germany 2025 on May 8-9Conference: POSETTE: An Event for Postgres 2025 on Jun 10-12Upcoming 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 4Conference: PGDay UK 2025 happening in London on Sep 9Conference: PGDay Lowlands 2025 happening in Rotterdam on Sep 12Video from PGConf.dev 2024: Making PostgreSQL Hacking More InclusiveTalking Postgres podcast: How I got started as a developer (& in Postgres) with David RowleyWikipedia: 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)”
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: psycopgDocumentation: Psycopg 3 – PostgreSQL database adapter for PythonProject page: PostgreSQL open source projectGit repo: code for PostgreSQL.org websiteConference: PyCon US 2025, happening May 14-22 in PittsburghConference: PGConf.dev 2025 Schedule, happening May 13-16 in Montreal CanadaConference: Prague PostgreSQL Developer Day 2025 (P2D2) Schedule, which took place Jan 28-29Wikipedia page: Model-view-controller software design patternBook: Professional ASP.NET MVC 1.0, affectionately called “the four heads book”Podcast episode: Working in Public with Simon Willison & Marco SlotBlog: Simon Willison's TILs, aka Things I've learnedSimon Willison's Weblog: Here's how I use LLMs to help me write codeSimon Willison's Weblog: How I make annotated presentationsSurvey: Python Developers Survey 2023 ResultsPython Docs: What's new in Python 3.14Mentorship program: Djangonaut SpaceMentorship program: Media & Talks about Djangonaut SpacePodcast episode: Why mentor Postgres developers with Robert HaasSlides: PGConf EU 2024 talk by Claire Giordano about Contributions to Postgres, including maps showing how global the Postgres project isVideo of POSETTE 2024 talk by Paolo Melchiorre: Semantic search with Django, PostgreSQL, & pgvectorVideo of Citus Con 2023 talk: Maps with Django (and PostGIS), by Paolo MelchiorreVideo of Citus Con 2022 talk: Django with PostgreSQL superpowers, by Paolo MelchiorreConference: 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
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 80Wikipedia: mSQLWikipedia: PCBoard BBS (bulletin board system) applicationConference back in 2010: CHAR(10) – Clustering, HA and Replication ConferenceWikipedia: IRIX operating systemInternet 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 FearingConference: Nordic PGDay 2025 to happen Mar 18th in CopenhagenConference: All Things Open 2025 to happen Oct 12-14 in Raleigh NCConference: PGConf.dev 2025 to happen May 13-16 in Montreal, CanadaCFP: 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 timeframeVideo of PGConf EU 2024 Talk: Analysis of contributions in the v17 timeframe, by Claire GiordanoBook recommendation: The Dragon Book, a.k.a. Compilers: Principles, Techniques, and ToolsBook 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 & PikeCalendar invite: LIVE recording of Ep24 of Talking Postgres podcast to happen on Wed Feb 05, 2025 with guest Robert Haas
Nikolay and Michael discuss why they chose Postgres — as users, for their businesses, for their careers, as well as some doubts. Here are some links to things they mentioned:Our episode on why Postgres become popular https://postgres.fm/episodes/why-is-postgres-popularDatabase Systems: The Complete Book (by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom) http://infolab.stanford.edu/~ullman/dscb.htmlOur episode on the Postgres startup ecosystem https://postgres.fm/episodes/postgres-startup-ecosystemWill Postgres Live Forever? (talk by Bruce Momjian) https://www.youtube.com/watch?v=iYVxWpyaGpA Constitutional Peasants from Monty Python and the Holy Grail https://www.youtube.com/watch?v=t2c-X8HiBngThe Cathedral and the Bazaar: Musings on Linux and Open Source by an Accidental Revolutionary (book by Eric S. Raymond) https://en.wikipedia.org/wiki/The_Cathedral_and_the_Bazaar ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
With Nikolay taking a well-earned break, Michael covers the basics of EXPLAIN — what it is, the parameters available, and a process he recommends for using it. Here are some links to the things mentioned:EXPLAIN (docs) https://www.postgresql.org/docs/current/sql-explain.htmlUsing EXPLAIN (docs) https://www.postgresql.org/docs/current/using-explain.htmlEXPLAIN Explained (talk by Josh Berkus https://www.youtube.com/watch?app=desktop&v=mCwwFAl1pBUBeyond joins and indexes (slides from talk by Bruce Momjian) https://momjian.us/main/writings/pgsql/beyond.pdfDepesz https://explain.depesz.comDalibo https://explain.dalibo.compgMustard https://www.pgmustard.com/A beginners guide to explain (talk by Michael) https://www.youtube.com/watch?v=31EmOKBP1PY&t=24sExplain beyond the basics (talk by Michael) https://www.youtube.com/watch?v=sGkSOvuaPs4auto_explain episode https://postgres.fm/episodes/auto_explainRow estimates episode https://postgres.fm/episodes/row-estimatesSlow queries and slow transactions episode https://postgres.fm/episodes/slow-queries-and-slow-transactionsBenchmarking episode https://postgres.fm/episodes/benchmarkingEXPLAIN glossary by Michael (forgot to mention, oops!) https://www.pgmustard.com/docs/explain~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is brought to you by:Nikolay Samokhvalov, founder of Postgres.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork
Nikolay and Michael discuss connections — the options, security and performance tradeoffs, and a few other things to be aware of. Here are some links to some things they mentioned:Episode on connection poolers https://postgres.fm/episodes/connection-poolers listen_addresses https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-LISTEN-ADDRESSES SSLMODE Explained (blog post by Andrew Kane) https://ankane.org/postgres-sslmode-explained pg_hba.conf https://www.postgresql.org/docs/current/auth-pg-hba-conf.htmlTiming a query (blog post by Bruce Momjian) https://momjian.us/main/blogs/pgblog/2012.html#June_6_2012 How to connect (blog post by Lætitia Avrot) https://mydbanotebook.org/post/cant-connect/ Improving Postgres Connection Scalability: Snapshots (blog post by Andres Freund) https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/improving-postgres-connection-scalability-snapshots/ba-p/1806462 idle_session_timeout https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-IDLE-SESSION-TIMEOUT Do you vacuum everyday? (talk by Hannu Krosing) https://www.youtube.com/watch?v=JcRi8Z7rkPg Don't use now() with pg_stat_activity (tweet by Nikolay) https://twitter.com/samokhvalov/status/1664981076014690304 ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is brought to you by:Nikolay Samokhvalov, founder of Postgres.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork
Bruce and the Hoss catch up on all things Open Source and PostgreSQL. They talk about the impact of the war in Ukraine on the PostgreSQL community & the rise of protest ware in open source. Matt and Bruce also jump into the impact of end user/developers feelings towards databases in general on the future of PostgreSQL development. Some developers care about databases but don't have time, but there are others who don't care. How do we involve both of these groups and inspire them? Will derivative projects based on PostgreSQL help or hinder this effort? Tune in and hear our thoughts.
Software Engineering Radio - The Podcast for Professional Software Developers
This week, Postgres server developer Bruce Momjian joins host Robert Blumen for a discussion of multi-version concurrency control (MVCC) in the Postgres database. They begin with a discussion of the isolation requirement in database transactions (I in ACID); how isolation can be achieved with locking; limitations of locking; how locking limits concurrency and creates variability in query runtimes; multi-version concurrency control as a means to achieve isolation; how Postgres manages multiple versions of a row; snapshots; copy-on-write and snapshots; visibility; database transaction IDs; how tx ids, snapshots and versions interact; the need for locking when there are multiple writers; how MVCC was added to Postgres; and how to clean up unused space left over from aged-out versions.
Bruce Momjian, Vice President, Postgres Evangelist at EDB sat down with the HOSS Matt Yonkovit to talk through the current trends in database technology as well as to get details on the release of Postgres 14. Bruce has been around the database space for more than 30 years : He is a co-founder and core team member of the PostgreSQL Global Development Group as well as a known speaker, author, and contributor in the PostgreSQL community who has appeared at many international open-source conferences. Recently he visited Percona Live and talked to us about how to choose the best hardware for PostgreSQL in the cloud.
Software Engineering Radio - The Podcast for Professional Software Developers
Bruce Momjian, a longtime Postgres developer, educator and consultant joins Robert Blumen for a discussion of the SQL query planner in the Postgres relational database. Topics covered include what is a query? How queries are evaluated by the server; the phases of query evaluation; SQL as a declarative language; why declarative query evaluation is simpler […]
Software Engineering Radio - The Podcast for Professional Software Developers
Postgres developer Bruce Momjian joins Robert Blumen for a discussion of the SQL query optimizer in the Postgres RDBMS. They delve into the internals of query planning and look at how developers can make it work for their apps.
Following on from our previous look at the Query planner - we are joined again by Bruce Momjian to extend this exploration into looking how Postgres manages concurrency. We start off by discussing some of the challenges and workarounds used in the past to handle concurrent access, particularly in the eyes of a database administrator. We then highlight the concept of MVCC, how it works from a high-level, how Postgres implements it and the clean-up considerations that are present. Finally, we mention how Postgres stores data in page-form, how projects such as pg_compact work to regain space and what the fill-factor is.
In this weeks episode we are very lucky to be joined by Bruce Momjian to discuss Postgres Performance Tuning and Query Planner. We start off discussion around how Bruce got interested in Database Systems, a brief history of Postgres and his involvement with the project over the years. Following this we highlight the three main areas which affect database performance - hardware, server configuration and SQL/indexing. With this knowledge in hand, we then delve into the Query Planner, demystifying some of the terminology and concepts used (i.e. cost, scan methods and join methods). Finally, we summarise how these concepts are used by Postgres to decide which query plan to pick for a supplied query.
Before connecting a new install to the InternetMake sure you have a strong root passwordCreate a regular user account for your useMake sure you have applied all patches and updatesUnderstand the purpose for any listening processInterview with PostgreSQL core developer Bruce Momjian
Новости Rollout от Джеймса Голика Вышел JRuby 1.7.0 Много вещей, которые умеет делать Ruby, а вы не знали Ruby Scaffolding as a Service Clap - еще один парсер командной строки Используемые технологии среди победителей Rails Rumble Быстрый CityHash Вышла Ruby Under a Microscope Passenger поддерживает JRuby и Rubinius Если вы еще не знаете что такое символы в Ruby, это видео для вас! Быстрая замена Nokogiri: бенчмарк и сам проект Ox Обсуждение Ванин позор в 19 эпизоде по поводу скандального интервью с DHH Конференция Highload++ Коллега Никита Борзых в твиттере Chef-рецепт postgresql от Express42 Конференция PostgreSQL Conference Europe Репликация в PostgreSQL Postgres-XC Postgres R, официальный сат лежал на момент подготовки подкаста Londiste Slony Bucardo Инструменты для анализа запросов в PostgreSQL PgFouine pgBadger pgstatstatements Менеджер соединений для PostgreSQL - pgBouncer Bruce Momjian — там в разделе Presentations есть его презентации, о которых рассказывалось в подкасте Пражский рубист Эдуард