Podcast Episodes

Disks

Episode 156

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 …

7 months ago

View Episode

Multi-column indexes

Episode 155

Nik and Michael discuss multi-column indexes in Postgres — what they are, how to think about them, and some guidance around using them effectively.
 
H…

7 months, 1 week ago

View Episode

Self-driving Postgres

Episode 154

Nikolay and Michael discuss self-driving Postgres — what it could mean, using self-driving cars as a reference, and ideas for things to build and opt…

7 months, 2 weeks ago

View Episode

caSe-inSENsiTive

Episode 153

Nikolay and Michael discuss case-insensitive data — when we want to treat columns as case-insensitive, and the pros and cons of using citext, functio…

7 months, 3 weeks ago

View Episode

Monitoring from Postgres AI

Episode 152

Nikolay talks to Michael about Postgres AI's new monitoring tool — what it is, how its different to other tools, and some of the thinking behind it.
 …

8 months, 1 week ago

View Episode

MultiXact member space exhaustion

Episode 151

Nikolay and Michael are joined by Andrew Johnson and Nate Brennand from Metronome to discuss MultiXact member space exhaustion — what it is, how they…

8 months, 2 weeks ago

View Episode

Multigres

Episode 150

Nikolay and Michael are joined by Sugu Sougoumarane to discuss Multigres — a project he's joined Supabase to lead, building an adaptation of Vitess f…

8 months, 3 weeks ago

View Episode

Multi-tenant options

Episode 149

Nikolay and Michael are joined by Gwen Shapira to discuss multi-tenant architectures — the high level options, the pros and cons of each, and how the…

9 months, 2 weeks ago

View Episode

Mean vs p99

Episode 148

Nikolay and Michael discuss looking at queries by mean time — when it makes sense, why ordering by a percentile (like p99) might be better, and the m…

9 months, 3 weeks ago

View Episode

What to log

Episode 147

Nikolay and Michael discuss logging in Postgres — mostly what to log, and why changing quite a few settings can pay off big time in the long term.
 
He…

9 months, 4 weeks ago

View Episode