Podcast Episodes
Back to SearchWhat 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, 2 months 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…
1 year, 2 months 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…
1 year, 2 months 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…
1 year, 3 months 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…
1 year, 3 months 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 …
1 year, 3 months 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…
1 year, 4 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 …
1 year, 4 months ago
PgDog
Episode 139
Nikolay and Michael are joined by Lev Kokotov to discuss PgDog — including whether or when sharding is needed, the origin story (via PgCat), what's a…
1 year, 4 months ago
Snapshots
Episode 138
Nikolay talks Michael through using cloud snapshots — how they can be used to reduce RTO for huge Postgres setups, also to improve provisioning time,…
1 year, 4 months ago