A weekly podcast about all things PostgreSQL
134 episodes transcribedNikolay and Michael discuss PostgreSQL events — whether in-person or online, large conferences or small meet-ups, as well as some strong opin...
Nikolay and Michael discuss PostgreSQL subtransactions — what they are, and four issues they can cause at scale. Here are some links to thin...
Nikolay and Michael discuss companion databases — when and why you might want to add another database management system to your stack (or not...
Nikolay and Michael discuss blue-green deployments — specifically an RDS blog post, how similar this is (or not) to what they understand to b...
Nikolay and Michael discuss data model trade-offs — some cases where you might want to (gasp) de-normalize, and which PostgreSQL internals ar...
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...
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 ha...
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 eco...
In this episode (recorded live on YouTube), Nikolay discusses Postgres shutdown and startup times – how to troubleshoot them and, when needed...
Nikolay and Michael discuss Postgres backups — why we need them, what the options are, whether a dump is a backup or not, and some considerat...
Nikolay and Michael discuss the release of PostgreSQL 16 — the most important new features, what they mean for us as users, whether and when...
Nikolay and Michael discuss logical replication — some history, initialization, change data capture, how to scale it, some limitiations, and...
Nikolay and Michael discuss their favourite feature each from the upcoming PostgreSQL 16 release. Here are some links to some things they men...
Nikolay and Michael discuss connections — the options, security and performance tradeoffs, and a few other things to be aware of. Here are so...
Nikolay and Michael discuss a listener question — about products that take Postgres and transform it to something that decouples compute from...
Nikolay and Michael discuss self-managing Postgres — both the practicalities of doing so, as well as some managed-service style tooling. Her...
Nikolay and Michael discuss sharding Postgres — what it means, why and when it's needed, and the available options right now. Here are some...
Nikolay and Michael discuss data types in PostgreSQL — including system types, choosing between types, types provided by extensions, and more...
Nikolay and Michael discuss HA (high availability) — what it means, tools and techniques for maximising it, while going through some of the m...
Nikolay and Michael discuss 10 beginner tips Nikolay recently shared — they go into a bit more detail on each, and even disagree a little on...
