A weekly podcast about all things PostgreSQL — by @michristofides and @samokhvalov. Also at fosstodon.org/@postgresfm

Joined July 2022
Photos and videos
Due to travelling and holidays we’re taking a few weeks off, but we’re excited to be back after that!
4
237
New episode: "autovacuum" Nik and Michael discuss autovacuum, including what it does, and the basics of why and how to tune it. 🎧 postgres.fm/episodes/autovac… 📺 youtu.be/WMNjHTgYH_c
6
293
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_flig… 📺 youtu.be/UirSQIY8_M0
3
12
1,878
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
1
2
9
1,964
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_wait… 📺 youtu.be/efY85jwfcQ8
2
7
2,760
New episode: "Schema design checklist" Nik and Michael discuss a list of things to check when designing new schema in Postgres. 🎧 postgres.fm/episodes/schema-… 📺 youtu.be/Z3AboE-kFZU
14
6,131
New episode: "What's missing in Postgres?" Nik and Michael are joined by Bruce Momjian to discuss his new talk. 🎧 postgres.fm/episodes/what-s-… 📺 youtu.be/F3FMvni6j2U
1
4
11
4,072
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-ru… 📺 youtu.be/uSUpbUJM5Kk
5
37
1,913
New episode: "PostGIS" @samokhvalov and @michristofides are joined by @reginaobe and @pwramsey to discuss @PostGIS 🎧 postgres.fm/episodes/postgis 📺 youtu.be/JDULwjz1hDY
1
4
13
1,329
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-fl… 📺 youtu.be/sjv_D18QwTs
2
5
1,718
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
4
1,070
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/comment… 📺 youtu.be/D-xmGGuq-fM
1
3
338
New episode: "PgDog update" @samokhvalov and @michristofides are joined by Lev Kokotov for an update on all things PgDog. 🎧 postgres.fm/episodes/pgdog-u… 📺 youtu.be/0hoygJJezdw
3
8
2,774
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/regresq… 📺 youtu.be/ygU8rXuqfsw
1
7
1,409
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/postgre… 📺 youtu.be/CQ5Fr5uHEp0
2
5
665
New episode: "Archiving" Nik and Michael discuss a listener question about archiving a database. 🎧 postgres.fm/episodes/archivi… 📺 youtu.be/dlelSPtMzWg
1
5
715
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_con… 📺 youtu.be/KFRK8PiIvTg
1
8
2,024
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-n… 📷 youtu.be/DaCItrWCXlE
1
4
832
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-of… 📺 youtu.be/ff-goIbd-Zk
4
14
7,682
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/gapless… 📺 youtu.be/3uIXr92GRWo
1
3
5
1,132