🔥The 9th Round of Easy Loan, Earn $40 Reward is in progress❗️ ⏰ Promotion Period: January 15th - Feburary 15th, 2025 👉 Register now and check more details at gate.io/campaigns/358

New episode: "Custom vs generic plan" Nikolay and Michael discuss prepared statement planning — how issues present themselves, some ways to get the generic plan, and some benefits of avoiding planning (not just time). 🎧 postgres.fm/episodes/custo… 📺 youtu.be/gYFiYhMgf98

New episode: "Minor releases" Nikolay and Michael discuss Postgres minor releases — how the schedule works, options for upgrading to them, and the importance of reading the release notes! 🎧 postgres.fm/episodes/minor… 📺 youtu.be/yvR0IqTRihk

New episode: "Full text search" Nikolay and Michael discuss full text search in Postgres — some of the history, some of the features, and whether it now makes sense to try to replace or combine it with semantic search. 🎧 postgres.fm/episodes/full-… 📺 youtu.be/2kGn1_aWU7o

New episode: "Sponsoring the community" Michael is joined by Claire Giordano ✨ from Microsoft, to discuss ways to contribute to the Postgres community — from core contributions, to extensions, to events, and more. 🎧 postgres.fm/episodes/spons… 📺 youtube.com/watch?v=bo0o9p…

New episode: "To 100TB, and beyond!" For episode 100, Michael and Nikolay are joined by 3 special guests — Arka from Notion, Sammy from Figma, and Derk from Adyen — to discuss scaling setups, challenges, and strategies! 🎧 postgres.fm/episodes/to-10… 📺 youtube.com/watch?v=L6JWI2…

New episode: "pgvectorscale" Nikolay is joined by Mat Arye and John Pruitt, from Timescale, to discuss their new extension pgvectorscale and high-performance vector search in Postgres more generally. 🎧 postgres.fm/episodes/pgvec… 📺 youtube.com/live/dX6xbManL…

New episode: "Should we use foreign keys?" Nikolay and Michael discuss foreign keys — what they are, some pros and cons, some improvements coming, and whether or not they generally recommend using them. 🎧 postgres.fm/episodes/shoul… 📺 youtu.be/I3ZX4aGgi1Q

New episode: "Soft delete" Nikolay and Michael discuss soft deletion in Postgres — what it means, several use cases, some implementation options, and which implementations suit which use cases. 🎧 postgres.fm/episodes/soft-… 📺 youtu.be/n1vqizmB__o

On YouTube, our episodes are equipped with subtitles, and we put some good effort to have them done right. And YouTube can provide automated translation (also of good quality!) for the language you need. Check it out: youtube.com/PostgresTV

New episode: "4 million TPS" Nikolay talks Michael through a recent experiment to find the max TPS single-node Postgres can achieve — why look into it, what bottlenecks he hit, and ideas for follow up experiments. 🎧 postgres.fm/episodes/four-… 📺 youtu.be/QJPyyEQFRZc

New episode: "Postgres startup ecosystem" Nikolay and Michael discuss Postgres startups — some closures, some fundraising announcements, where things are going, and what they'd like to see. 🎧 postgres.fm/episodes/postg… 📺 youtu.be/fIqYOXhMR-o

New episode: "Out of disk" Nikolay and Michael discuss Postgres running out of disk space — what happens, what can cause it, how to recover, and how to prevent it from happening in the first place. 🎧 postgres.fm/episodes/out-o… 📺 youtu.be/BN5V2fYBDyo

New episode: "Compression" Nikolay and Michael discuss compression in Postgres — what's available natively, newer algorithms in recent versions, and several extensions with compression features. 🎧 postgres.fm/episodes/compr… 📺 youtu.be/N1yhAgM0wKE

New episode: "Why Postgres?" Nikolay and Michael discuss why they chose PostgreSQL — as users, for their businesses, for their careers, as well as some doubts. 🎧 postgres.fm/episodes/why-p… 📺 youtu.be/2F0fSj2Zem8

New episode: "Index-Only Scans" Nikolay and Michael discuss Index-Only Scans in Postgres — what they are, how they help, some things to look out for, and some advice. 🎧 postgres.fm/episodes/index… 📺 youtu.be/0SROLA-aBqY

New episode: "Getting started with benchmarking" Nikolay and Michael are joined by Melanie Plageman to discuss benchmarking — how it differs for users and developers, some tools and lessons, and what she's working on now. 🎧 postgres.fm/episodes/getti… 📺 youtu.be/xR-VJjR9DPQ

New episode: "Get or Create" Michael and Nikolay are joined by Haki to discuss the surprisingly complex topic of trying to implement “get or create” in Postgres (with idempotency, concurrency, and minimising bloat). 🎧 postgres.fm/episodes/get-o… 📺 youtu.be/59CainMBjtQ

New episode: "Postgres Emergency Room" Nikolay and Michael discuss PostgreSQL emergencies — both the psychological side of incident management, and some technical aspects too. 🎧 postgres.fm/episodes/postg… 📺 youtu.be/Rn_5tTX1tDY

Just listened to “Getting started with benchmarking” by Postgres FM . Insightful. I did some query perf benchmarking a while back on postgres running on AMD vs ARM and the lessons learned today have helped me identify a couple of really good and meh things I did there 😄

New episode: "Skip scan" Michael and Nikolay are joined by Peter Geoghegan, major contributor and committer to Postgres, to discuss adding skip scan support to PostgreSQL over versions 17 and 18. 🎧 postgres.fm/episodes/skip-… 📺 youtu.be/Xk-znJgQzQs