New episode: "Multigres". Nikolay and Michael are joined by @ssougou to discuss Multigres — a project he's joined Supabase to lead, building an adaptation of Vitess for Postgres!. 🎧 📺

New episode: "Multi-tenant options". Nikolay and Michael are joined by @gwenshap to discuss multi-tenant architectures — the high level options, the pros and cons of each, and how they're trying to help with Nile. 🎧 📺

New episode: "Mean vs p99". Nik and Michael discuss looking at queries by mean time — when it makes sense, why ordering by p99 might be better, and the merits of approximating percentiles using the standard deviation. 🎧 📺

New episode: "What to log". Nikolay and Michael discuss logging in Postgres — mostly what to log, and why changing quite a few settings can pay off big time in the long term. 🎧 📺

New episode: "How to move off RDS". Nikolay and Michael discuss moving off managed services — when and why you might want to, and some tips on how for very large databases. 🎧 📺

New episode: "Locks". 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. 🎧 📺

New episode: "Top ten dangerous issues". 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 then what you can do proactively. 🎧 📺

New episode: "synchronous_commit". Nikolay and Michael discuss synchronous_commit — what it means on single node setups, for synchronous replication setups, and the pros and cons of the different options for each. 🎧 📺

New episode: "Managed service support". Nikolay and Michael discuss managed service support — tips for cases that aren't going well, requesting features, factoring in support when choosing, and whether to use one at all. 🎧 📺

New episode: "Time-series considerations". Nikolay and Michael discuss time-series considerations for Postgres — including when it matters, some tips for avoiding issues, performance considerations, and more. 🎧 📺

New episode: "Performance cliffs". Nikolay and Michael are joined by Tomas Vondra to discuss performance cliffs — what they are, why they happen, and some things we can do to make them less likely or less severe. 🎧 📺

New episode: "PgDog". 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 already supported, and what's coming next. 🎧 📺

New episode: "Snapshots". Nikolay talks Michael through using cloud snapshots — how they can be used to reduce RTO for huge Postgres setups, also to improve provisioning time, and some major catches to be aware of. 🎧 📺

New episode: "GIN Indexes". Nikolay and Michael discuss GIN indexes in Postgres — what they are, what they're used for, and some limitations to be aware of. 🎧 📺

New episode: "Best Practices". Nikolay and Michael use a recent "best practices" article as a prompt — giving a few tips each on the topics mentioned, like schema design, performance, backups, and more. 🎧 📺

New episode: "Extended Statistics". 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. 🎧 📺

New episode: "SQL vs NoSQL". Nikolay and Michael are joined by @FranckPachot to discuss SQL vs NoSQL — did Franck change teams by joining MongoDB, normalisation vs denormalisation, developer experience, NULLs, and more!. 🎧 📺

New episode: "Return of the BUFFERS". Nikolay and Michael return to this topic for the third (and final?) time — discussing the news that it'll be on by default in Postgres 18, and what effect(s) that might have. 🎧 📺

New episode: "Reads causing writes". Nikolay and Michael discuss a couple of surprising ways read queries (selects) can cause writes (shared buffers dirtied) in Postgres. 🎧 📺

New episode: "NOT VALID constraints". Nikolay and Michael discuss adding constraints in an online fashion, using NOT VALID and then VALIDATE CONSTRAINT. 🎧 📺