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 they're trying to help with Nile.
Here are some links…
Published on 2 months, 4 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 3 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 3 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 3 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 3 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 then what you can do proactively.
The ten issues disc…
Published on 4 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 the different options for each.
Here are some links …
Published on 4 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 to factor in support when choosing service provide…
Published on 4 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 considerations, and more.
Here are some links to things the…
Published on 5 months, 1 week 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 make them less likely or less severe, and some pot…
Published on 5 months, 2 weeks ago