Bruce Momjian - Podcast Details

Shows

Compiled Conversations The Life of a PostgreSQL Table, Part 2 with Bruce MomjianBruce Momjian returns to complete our exploration of PostgreSQL internals through a table’s lifecycle. From updates and alterations to deletions and drops, we dive deep into how Postgres manages data changes, maintains consistency, and handles clean-up operations, revealing the intricate mechanisms that make PostgreSQL both powerful and reliable. We examine how Postgres manages everything from transaction isolation to reclaiming space. Bruce explains how MVCC enables concurrent updates, how table alterations affect performance, and how the Write-Ahead Log ensures durability whilst enabling features like point-in-time recovery and replication. Topics include: Updates: MVCC, heap-only tuples, an...

2025-10-1342 min

Compiled Conversations The Life of a PostgreSQL Table, Part 1 with Bruce MomjianBruce Momjian returns to explore the internals of PostgreSQL by way of a table’s lifecycle. From creation through insertion to querying, we dive deep into how Postgres actually implements tables, indexes, and queries under the hood, revealing why understanding these internals helps you make better decisions as a database user. We examine how Postgres handles everything from physical storage to transaction visibility. Bruce explains why constraints are critical for data integrity, how MVCC enables consistent reads without blocking writes, and how the query planner makes decisions about accessing your data. Topics include: Table cr...

2025-10-011h 25

Compiled Conversations All Aboard the PostgreSQL Train with Bruce MomjianBruce Momjian joins us to explore why PostgreSQL continues to outpace proprietary databases - not just in features, but also in its development model and architecture. We trace Postgres’s 39-year lineage - from its Berkeley origins and Michael Stonebraker’s vision for extensibility, through early debates about removing that extensibility, to the decades in which that design proved pivotal. That architecture has paid off repeatedly, enabling JSON/JSONB, full-text search, PostGIS, and pgvector to land at the right moments without upheaval. Bruce explains why transparent data encryption (TDE) hasn’t landed in core, when sharding actually helps...

2025-09-031h 24

Talking Postgres with Claire Giordano Open Source Leadership with Bruce MomjianWhat 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 se...

2025-04-041h 48

Technogram The Open-Source Edge: Why Enterprises Are Betting on PostgresIn this episode of the Technogram by Redington, we sit down with Bruce Momjian, Vice President and Postgres Evangelist at EDB. With decades of experience in technology, Bruce shares his journey into the world of open-source software and his deep expertise in Postgres. He also discusses how open-source technologies, like Postgres, align with Saudi Vision 2030, the evolution of open-source conversations, and why Postgres is the future of enterprise IT infrastructureConnect with Technogram by Redington➡️ Follow on Spotify:https://bit.ly/TechnoGramSP ➡️ Follow on Apple Podcast:shttps://podcasts.apple.com/us/p...

2025-03-2111 min

Talking Postgres with Claire Giordano How I got started as a developer & in Postgres with Daniel GustafssonMarch 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 i...

2025-01-171h 22

Quest podcasts Episode 4 – Discussing PostgreSQL at PGNYC 2024: No Longer The Elephant in the Room (or “The Secret To Its Success Is In The Community”)Quest Software recently participated in the PG NYC show in Manhattan, New York where we met with hundreds of DBAs, developers, administrators, decision makers and contributors to the open source PostgreSQL database. It’s a fabulous 3 day show where we learned how PostgreSQL is used by organizations large and small across the globe, and discovered how to get the most out of the platform – as well as discussed what’s coming next. During the show, Quest Marketing Director Mike “The Reluctant Product Marketer” O’Donnell, Quest Senior Sales Engineer Clay Jackson and Mark Gowdy sat down for interviews with Bruce Momjian...

2024-10-291h 05

Postgres FM Why Postgres?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 "Anarcho-Syndicalist Commune" from Monty Python and the Holy Grail https://www.youtu...

2024-08-0241 min

Plays On Word Radio Ep 51: Unwavering Faith (Part 1) – Christmas Reflections and Armenian Quest for PeaceSend a text"Join us as we first dissect the complex tapestry of Christmas. Transitioning from the well-trodden paths of Jerusalem, we then navigate the storied resilience of the Armenian Church, a testament to faith’s enduring flame."PlayGrounds section: Today's PlayGround section was recorded after our 'CHRISTMAS JOE' performance.Vicken & Jeannette Keshishian, Bruce & Christine Momjian, Wilma Cholakian • Armenian Martyrs' Congregational Church • Havertown, PAWebsite: https://www.amccpa.org/ • Facebook: https://www.facebook.com/amcc...

2024-01-1229 min

Postgres FM EXPLAINWith 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.pgm...

2024-01-0519 min

Postgres FM ConnectionsNikolay 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://mydbanot...

2023-09-0128 min

Postgres FM TimestampsHere are links to a few things we mentioned: Date/Time Types (docs) Don’t use timestamp without time zone (wiki) Date/Time functions and operators (docs) Postgres AT TIME ZONE explained (blog post by Bruce Momjian) Our episode on BRIN indexes RUM indexes allballs (mailing list thread) ------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.If you would like to share this episode, here's a good link...

2022-12-0926 min

Postgres FM How to become a DBAAnd few things we mentioned: Topic request on Reddit — thanks HerbyHoover!Haki Benita's blog PostgreSQL documentation (table of contents) Planet PostgreSQL (blog aggregator) MVCC Unmasked (by Bruce Momjian) The Internals of PostgreSQL (by Hironobu SUZUKI)PostgreSQL 14 Internals — parts I and II (by Egor Rogov)Cybertec blogmodern-sql.com (by Markus Winand)use-the-index-luke.com (by Markus Winand)The Art of PostgreSQL (by Dimitri Fontaine) explain.depesz.comexplain.dalibo.com ------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofidesIf you would l...

2022-08-2632 min

Software Engineering Radio - the podcast for professional software developers Episode 496: Bruce Momjian on Multi-Version Concurrency Control in Postgres (MVCC)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...

2022-01-251h 00

Software Engineering Radio - The Podcast for Professional Software Developers Episode 496: Bruce Momjian on Multi-Version Concurrency Control in Postgres (MVCC)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...

2022-01-251h 00

The Christ and Coffee Podcast Wisdom From Software Innovator Bruce MomjianWhat could two pastors and a software developer possibly have to talk about together? Turns out … a lot! Bruce Momjian, co-founder of PostgreSQL, shares some leadership tips he’s learned along the way and offers us up wisdom for living well in a tech society. He also shares his story of becoming a Jesus-follower and accepting Him without having all the answers.

2020-07-0940 min

Linux Inlaws HPR3106: Linux Inlaws S01E09 PostgresS01E09: Postgres Listen to our two OAP interviewing Bruce Momjian, Postgres evangelist and long-time supporter of this popular SQL database. Expect lots of strong language around SQL and NoSQL topics and some ranting about MINT's attitude towards snaps, a fun breach of a health service provider in the UK and why broadcasters should stick to monopolies. MINT Chromium issue: https://blog.linuxmint.com/?p=3766 PostgreSQL: https://www.postgresql.org Babylon Health breach: https://www.bbc.com/news/technology-52986629

2020-06-2900 min

Software Engineering Radio - The Podcast for Professional Software Developers SE-Radio Episode 328: Bruce Momjian on the Postgres Query PlannerPostgres 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.

2018-06-191h 03

Software Engineering Radio - the podcast for professional software developers SE-Radio Episode 328: Bruce Momjian on the Postgres Query PlannerPostgres 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.

2018-06-191h 03

Three Devs and a Maybe 117: Managing Concurrency in Postgres with Bruce MomjianFollowing 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...

2017-01-241h 21

Three Devs and a Maybe 102: Postgres Performance Tuning and Query Planner with Bruce MomjianIn 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...

2016-06-1154 min

Full Stack Radio 40: Edd Mann - You Should Switch to PostgresSponsors:Laracasts, use coupon code FULLSTACK2016 for 50% off your first monthRollbar, sign up at https://rollbar.com/fullstackradio to try their Bootstrap Plan free for 90 daysLinks:Refactoring to Collections, Adam's bookEdd's BlogPostgreSQLACIDUsing JavaScript in PostgresPartial IndexesUsing JSON in PostgresCommon Table ExpressionsPostgres.appNavicat for PostgrespgAdminBruce Momjian's homepage, recommended by EddExplaining the Postgres Query OptimizerPostgreSQL Internals Through Pictures

2016-04-1951 min

Three Devs and a Maybe 93: You Know, You Know, You KnowOn this episode (where Edd says ‘You Know’ alot!) we start off with discussion surrounding Lew’s recent move. Following this, we chat about odd IE 9 bugs, PostgreSQL Query Optimiser internals, the NPM left-pad saga and Lumen. This leads us on to discuss different Database GUI applications, Lew’s fun with public-key API authentication and the anti-pattern of striving for ‘pretty’ URLs. Finally, we bring up the topic of handling email delivery, using DigitalOcean to host podcast episodes and an interesting tidbit on the ‘break’ control structure in PHP. Show Links Drop IE-specific status codes workarounds and require IE10...

2016-04-0259 min

Ruby NoName podcast Ruby NoName Podcast S04E21Новости 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 есть его презентации, о которых рассказывалось в подкасте Пражский рубист Эдуард

2012-11-0400 min