Podcast Episodes

Plan flips

Episode 173

Nik and Michael discuss query plan flips in Postgres — what they are, some causes, mitigations, longer term solutions, and the recent outage at Clerk…

7 months, 2 weeks ago

View Episode

pg_ash

Episode 172

Nik and Michael discuss pg_ash — a new tool (not extension!) from Nik that samples and stores wait events from pg_stat_activity.
 
Here are some links …

8 months ago

View Episode

Comments and metadata

Episode 171

Nik and Michael discuss query level comments, object level comments, and another way of adding object level metadata.
 
Here are some links to things t…

8 months, 1 week ago

View Episode

PgDog update

Episode 170

Nik and Michael are joined by Lev Kokotov for an update on all things PgDog.
 
Here are some links to things they mentioned:

Lev Kokotov https://postgre…

9 months ago

View Episode

RegreSQL

Episode 169

Nik and Michael are joined by Radim Marek from boringSQL to talk about RegreSQL, a regression testing tool for SQL queries they forked and improved r…

9 months, 1 week ago

View Episode

Postgres year in review 2025

Episode 168

Nik and Michael discuss the events and trends they thought were most important in the Postgres ecosystem in 2025.
 
Here are some links to things they …

9 months, 3 weeks ago

View Episode

Archiving

Episode 167

Nik and Michael discuss a listener question about archiving a database.
 
Here are some links to things they mentioned: 

Listener request to talk about …

10 months ago

View Episode

max_connections vs migrations

Episode 166

Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!)
 
Here …

10 months, 2 weeks ago

View Episode

What's new in EXPLAIN

Episode 165

Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18.
 
Here are some links to things they mentioned: 

EXPLAIN (official d…

11 months ago

View Episode

Tens of TB per hour

Episode 164

Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica.
 
Here are some links to…

11 months, 1 week ago

View Episode