Podcast Episodes
Back to Searchsynchronous_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, 5 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, 5 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, 6 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, 6 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, 6 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, 7 months 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, 7 months ago
Best Practices
Episode 136
Nikolay and Michael use a recent "best practices" article as a prompt — giving a few tips each on the topics mentioned, like schema design, performan…
1 year, 7 months ago
Extended Statistics
Episode 135
Nikolay and Michael discuss the CREATE STATISTICS feature in Postgres — what it's for, how often it's used, and how to spot cases where it would help…
1 year, 7 months ago
SQL vs NoSQL
Episode 134
Nikolay and Michael are joined by Franck Pachot to discuss SQL vs NoSQL — did Franck change teams by joining MongoDB, normalisation vs denormalisatio…
1 year, 8 months ago