Podcast Episodes
Back to SearchSelf-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 optimize for in this area.
Here are some links to thi…
Published on 2 months, 4 weeks ago
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, functions like lower(), or a custom collation.
Here are s…
Published on 3 months ago
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.
Here are some links to things they mentioned:
Published on 3 months, 2 weeks ago
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 managed to hit it, and some tips to prevent runni…
Published on 3 months, 3 weeks ago
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 for Postgres!
Here are some links to things they me…
Published on 4 months ago
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 they're trying to help with Nile.
Here are some links…
Published on 4 months, 3 weeks ago
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 merits of approximating percentiles in pg_stat_stat…
Published on 5 months ago
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.
Here are some links to things they mentioned:
Published on 5 months, 1 week ago
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 some links to things they mentioned:
Published on 5 months, 2 weeks ago
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.
Here are some links to things they mentioned:
Published on 5 months, 3 weeks ago