Podcast Episodes
Back to SearchSubtransactions
Episode 73
Nikolay and Michael discuss PostgreSQL subtransactions — what they are, and four issues they can cause at scale.
Here are some links to things they …
2 years, 11 months ago
Companion databases
Episode 72
Nikolay and Michael discuss companion databases — when and why you might want to add another database management system to your stack (or not), and s…
2 years, 11 months ago
Blue-green deployments
Episode 71
Nikolay and Michael discuss blue-green deployments — specifically an RDS blog post, how similar this is (or not) to what they understand to be blue-g…
2 years, 11 months ago
Data model trade-offs
Episode 70
Nikolay and Michael discuss data model trade-offs — some cases where you might want to (gasp) de-normalize, and which PostgreSQL internals are at pla…
2 years, 11 months ago
Under-indexing
Episode 69
Nikolay and Michael discuss under-indexing — how to tell if this applies to you, some general and specific cases, as well as some tricky ones.
Here …
2 years, 11 months ago
Over-indexing
Episode 68
Nikolay and Michael discuss over-indexing — what we mean by it, the regular issues people discuss about it, as well as a novel one Nikolay has come a…
3 years ago
Query hints
Episode 67
Nikolay and Michael discuss query hints — what they are, what we do and don't have in PostgreSQL, and some other things in and around the ecosystem t…
3 years ago
Stop and start Postgres faster
Episode 66
In this episode (recorded live on YouTube), Nikolay discusses Postgres shutdown and startup times – how to troubleshoot them and, when needed, optimi…
3 years ago
Backups
Episode 65
Nikolay and Michael discuss Postgres backups — why we need them, what the options are, whether a dump is a backup or not, and some considerations for…
3 years ago
Postgres 16
Episode 64
Nikolay and Michael discuss the release of PostgreSQL 16 — the most important new features, what they mean for us as users, whether and when to upgra…
3 years, 1 month ago