Podcast Episodes

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…

1 year, 2 months 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.
 …

1 year, 2 months 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…

1 year, 3 months 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…

1 year, 3 months 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…

1 year, 4 months 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…

1 year, 4 months 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…

1 year, 4 months ago

View Episode

How to move off RDS

Episode 146

Nikolay and Michael discuss moving off managed services — when and why you might want to, and some tips on how for very large databases.
 
Here are som…

1 year, 4 months ago

View Episode

Locks

Episode 145

Nikolay and Michael discuss heavyweight locks in Postgres — how to think about them, why you can't avoid them, and some tips for minimising issues.
 
H…

1 year, 5 months ago

View Episode

Top ten dangerous issues

Episode 144

Nikolay and Michael discuss ten dangerous Postgres related issues — ones that might be painful enough to get onto the CTO and even CEOs desk, and the…

1 year, 5 months ago

View Episode