Postgres FM

New episode: "pg_flight_recorder" Nik and Michael are joined by David Ventimiglia to discuss pg_flight_recorder, a new tool he created for monitoring a Postgres database from within. 🎧 postgres.fm/episodes/pg_fl… 📺 youtu.be/UirSQIY8_M0

New episode: "PgQue" Nik and Michael discuss Nik's new project PgQue, a descendent of Skype's PgQ, for running queue-like workloads in Postgres. 🎧 postgres.fm/episodes/pgque 📺 youtu.be/bBNcR14Ts4U

New episode: "pg_wait_tracer" Nik and Michael are joined by Dmitry Fomin to discuss his new tool pg_wait_tracer, as well as changes to core that would allow wait event tracing with lower overhead (and on managed services). 🎧 postgres.fm/episodes/pg_wa… 📺 youtu.be/efY85jwfcQ8

New episode: "Schema design checklist" Nik and Michael discuss a list of things to check when designing new schema in Postgres. 🎧 postgres.fm/episodes/schem… 📺 youtu.be/Z3AboE-kFZU

New episode: "What's missing in Postgres?" Nik and Michael are joined by Bruce Momjian to discuss his new talk. 🎧 postgres.fm/episodes/what-… 📺 youtu.be/F3FMvni6j2U

New episode: "Long-running transactions" Nik and Michael discuss long-running transactions, including when they're harmless, when they cause issues, and how to mitigate those issues. 🎧 postgres.fm/episodes/long-… 📺 youtu.be/uSUpbUJM5Kk

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