{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Talking Postgres with Claire Giordano","title":"Why it's fun to hack on Postgres performance with Tomas Vondra","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/5267062e\"></iframe>","width":"100%","height":180,"duration":5120,"description":"Why would anyone willingly spend weeks chasing a slow query, knowing they might hit dead ends along the way? In Episode 36 of Talking Postgres, Tomas Vondra—Postgres committer and long‑time performance contributor—joins Claire to explain why hacking on Postgres performance is not just hard, but also fun. We dig into the process of investigating why queries are slow, how iteration and “wrong turns” are part of performance work, and why Tomas prefers meaningful performance puzzles over toy problems. Along the way, we talk about using benchmarks to build an understanding of a problem. Tomas also shares how even small changes in code can have outsized impact when that code is used a lot, and how the mathematics embedded in the Postgres query planner/executor makes the work especially rewarding.\nPreviously on Talking Postgres:\nTalking Postgres Ep31: What went wrong (& what went right) with AIO with Andres Freund\nTalking Postgres Ep24: Why mentor Postgres developers with Robert Haas\nLinks mentioned in this episode:\nPGConf.dev 2026: Schedule\nGitHub repo: PostgreSQL Monthly Hacking Workshop, organized by Robert Haas \nNordic PGDay 2026: Tomas talk on approximating percentiles\nVideo of POSETTE 2025 talk: Performance Archaeology – 20 years of improvements\nVideo of PGConf EU 2025 talk: Fast-path locking improvements in PG18\nConference: Prague PostgreSQL Developer Day\nDiscord: PostgreSQL Hacking Discord\nGitHub repo: tvondra/tdigest\nBrendan Gregg’s site: perf Linux profiler examples\nDocs: pgbench for running benchmarks on PostgreSQL\nBlog: Tomas Vondra blog\nPostgres Patch Ideas: List on Tomas Vondra blog\nCalendar invite: LIVE recording of Ep37 of Talking Postgres to happen on Wed Mar 18, 2026","thumbnail_url":"https://img.transistorcdn.com/96oK6oMtH0qfumCURmVA4Hg7enGdZ1swehO6BOYsd8w/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS84OWEw/YmE3ZDQ5MDI3NzA5/MTljZThlODg3N2Qy/M2M1YS5wbmc.webp","thumbnail_width":300,"thumbnail_height":300}