Podcast Episodes
Back to SearchHow 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…
10 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…
10 months, 1 week 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…
10 months, 3 weeks 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…
11 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 …
11 months, 1 week 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…
11 months, 3 weeks 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 …
11 months, 4 weeks 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 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 ago
GIN Indexes
Episode 137
Nikolay and Michael discuss GIN indexes in Postgres — what they are, what they're used for, and some limitations to be aware of.
Here are some links …
1 year ago