Postgres FM

New episode: "PostGIS" @samokhvalov and @michristofides are joined by @reginaobe and @pwramsey to discuss @PostGIS 🎧 postgres.fm/episodes/postg… 📺 youtu.be/JDULwjz1hDY

New episode: "Plan flips" Nik and Michael discuss query plan flips in Postgres — what they are, some causes, mitigations, longer term solutions, and the recent outage at Clerk. 🎧 postgres.fm/episodes/plan-… 📺 youtu.be/sjv_D18QwTs

New episode: "pg_ash" Nik and Michael discuss pg_ash — a new tool (not extension!) from Nik that samples and stores wait events from pg_stat_activity. 🎧 postgres.fm/episodes/pg_ash 📺 youtu.be/uJ1LoZNCG_o

New episode: "Comments and metadata" Nik and Michael discuss query level comments, object level comments, and another way of adding object level metadata. 🎧 postgres.fm/episodes/comme… 📺 youtu.be/D-xmGGuq-fM

New episode: "PgDog update" @samokhvalov and @michristofides are joined by Lev Kokotov for an update on all things PgDog. 🎧 postgres.fm/episodes/pgdog… 📺 youtu.be/0hoygJJezdw

New episode: "RegreSQL" Nik and Michael are joined by Radim Marek from boringSQL to talk about RegreSQL, a regression testing tool for SQL queries (forked and improved). 🎧 postgres.fm/episodes/regre… 📺 youtu.be/ygU8rXuqfsw

New episode: "Postgres year in review 2025" Nik and Michael discuss the events and trends they thought were most important in the Postgres ecosystem in 2025. 🎧 postgres.fm/episodes/postg… 📺 youtu.be/CQ5Fr5uHEp0

New episode: "Archiving" Nik and Michael discuss a listener question about archiving a database. 🎧 postgres.fm/episodes/archi… 📺 youtu.be/dlelSPtMzWg

New episode: "max_connections vs migrations" Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!) 🎧 postgres.fm/episodes/max_c… 📺 youtu.be/KFRK8PiIvTg

New episode: "What's new in EXPLAIN" Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18. 🎧 postgres.fm/episodes/whats… 📷 youtu.be/DaCItrWCXlE

New episode: "Tens of TB per hour" Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica. 🎧 postgres.fm/episodes/tens-… 📺 youtu.be/ff-goIbd-Zk

New episode: "Gapless sequences" Nik and Michael discuss the concept of gapless sequences — when you might want one, why sequences in Postgres can have gaps, and an idea or two if you do want them. 🎧 postgres.fm/episodes/gaple… 📺 youtu.be/3uIXr92GRWo

New episode: "LWLocks" Nik and Michael discuss lightweight locks in Postgres — how they differ to (heavier) locks, some occasions they can be troublesome, and some resources for working out what to do if you hit issues. 🎧 postgres.fm/episodes/lwloc… 📺 youtu.be/DdQjvYHbIRU

New episode: "User management" Nik and Michael discuss user management in Postgres — how roles work, making administration easier, setting passwords, and avoiding them being logged. 🎧 postgres.fm/episodes/user-… 📺 youtu.be/KQcDZI81-kU

New episode: "Postgres 18" Nik and Michael discuss the newly released Postgres 18 — the bigger things it includes, some of their personal highlights, and some thoughts towards the future. 🎧 postgres.fm/episodes/postg… 📺 youtu.be/EIKU1seSqEY

New episode: "Gadget's use of Postgres" Nik and Michael are joined by @harrybrundage from @gadget_dev to talk about zero-downtime major version upgrades, what they use Postgres for, their dream database, and more! 🎧 postgres.fm/episodes/gadge… 📺 youtu.be/PAgQRfgk87A

New episode: "turbopuffer" Nik and Michael are joined by @Sirupsen from @turbopuffer to discuss ANN index types, tradeoffs for search workloads, and when it can make sense to move search out of Postgres. 🎧 postgres.fm/episodes/turbo… 📺 youtu.be/dgWmmbr_Fk8

New episode: "When not to use Postgres" Nik and Michael discuss when not to use Postgres — specifically use cases where it still makes sense to store data in another system. 🎧 postgres.fm/episodes/when-… 📺 youtu.be/gY3WNWNAxxw

New episode: "Disks" Nik and Michael discuss disks in relation to Postgres — why they matter, how saturation can happen, some modern nuances, and how to prepare to avoid issues. 🎧 postgres.fm/episodes/disks 📺 youtu.be/ajxMKRheORc

New episode: "Multi-column indexes" Nik and Michael discuss multi-column indexes in Postgres — what they are, how to think about them, and some guidance around using them effectively. 🎧 postgres.fm/episodes/multi… 📺 youtu.be/bhqYDvVTxP8