Podcast Episodes
Back to SearchMulti-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…
6 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 m…
7 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.
He…
7 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 som…
7 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.
H…
7 months, 3 weeks ago
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…
8 months, 1 week ago
synchronous_commit
Episode 143
Nikolay and Michael discuss synchronous_commit — what it means on single node setups, for synchronous replication setups, and the pros and cons of th…
8 months, 2 weeks ago
Managed service support
Episode 142
Nikolay and Michael discuss managed service support — some tips on how to handle cases that aren't going well, tips for requesting features, whether …
8 months, 3 weeks ago
Time-series considerations
Episode 141
Nikolay and Michael discuss time-series considerations for Postgres — including when it matters, some tips for avoiding issues, performance considera…
9 months ago
Performance cliffs
Episode 140
Nikolay and Michael are joined by Tomas Vondra to discuss single query performance cliffs — what they are, why they happen, some things we can do to …
9 months, 1 week ago