A weekly podcast about all things PostgreSQL
143 episodes transcribedNikolay 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...
Nikolay and Michael discuss Postgres connection poolers — when and why we need them, the king that is PgBouncer, and the many new pretenders...
Nikolay and Michael celebrate the podcast's 1 year anniversary by going through several questions and suggestions received over the year. Her...
Nikolay (alone, again) reveals some issues that might hit those who perform major PostgreSQL upgrades with minimal downtime.Links:- "Upgrades...
Lonely Nikolay discusses the performance aspects of using UUID for primary keys. Here are links to a few things I mentioned: "postgresql" pos...
Nikolay and Michael discuss memory in PostgreSQL — how it works, important settings, and how to go about tuning them. Here are links to a few...
Nikolay and Michael discuss Postgres extensions — what they are, how they affect your decisions around Postgres, and some things to keep in m...
Nikolay and Michael discuss zero-downtime schema migrations — why they're a challenge, a variety of different cases, and some things you can...
Nikolay and Michael discuss parallelism — both parallel query execution and other parallel operations. Here are links to a few things we ment...
Nikolay and Michael discuss database corruption — various types, how they can come about, and what to do (and not do) if you come across it. ...
Nikolay and Michael discuss using ChatGPT for Postgres tasks — should you, if so what for, and some things to be mindful of! Here are links t...
Nikolay and Michael discuss pg_stat_statements — why everyone should use it, but also some downsides! Here are links to a few things we menti...
