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
ALT Pictures of David, Nik, and Michael mid-recording, the episode title "pg_flight_recorder", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Nik and Michael mid-recording, the episode title "PgQue", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Dmitry, Nik, and Michael mid-recording, the episode title "pg_wait_tracer", against a pink backround with an elephant wearing sunglasses.
ALT Pictures of Nik and Michael mid-recording, the episode title "Schema design checklist", against a pink backround with an elephant wearing sunglasses.
ALT Pictures of Nik and Michael mid-recording, the episode title "Long-running transactions", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Nik and Michael mid-recording, the episode title "Long-running transactions", against a pink backround with an elephant wearing sunglasses.
ALT Pictures of Paul, Regina, Nik, and Michael mid-recording, the episode title "PostGIS", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Nik and Michael mid-recording, the episode title "Plan flips", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Nik and Michael mid-recording, the episode title "pg_ash", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Nik and Michael mid-recording, the episode title "Comments and metadata", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Radim, Nik, and Michael mid-recording, the episode title "RegreSQL", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Nik and Michael mid-recording, the episode title "Postgres year in review 2025", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Nik and Michael mid-recording, the episode title "max_connections vs migrations", against a pink backround with an elephant wearing sunglasses.
ALT Pictures of Nik and Michael mid-recording, the episode title "What's new in EXPLAIN", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Nik and Michael mid-recording, the episode title "Tens of TB per hour", against a pink backround with an elephant wearing sunglasses.
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
ALT Pictures of Nik and Michael mid-recording, the episode title "Gapless sequences", against a pink backround with an elephant wearing sunglasses.