🔥The 9th Round of Easy Loan, Earn $40 Reward is in progress❗️ ⏰ Promotion Period: January 15th - Feburary 15th, 2025 👉 Register now and check more details at gate.io/campaigns/358

New episode: "pg_squeeze" Michael and Nikolay are joined by Antonín Houska to discuss pg_squeeze — what it is, how it started, some of its features, and hopes of getting the functionality into core(!) 🎧 postgres.fm/episodes/pg_sq… 📺 youtu.be/8dXO0gnIwfQ

New episode: "NOT VALID constraints" Nikolay and Michael discuss adding constraints in an online fashion, using NOT VALID and then VALIDATE CONSTRAINT. 🎧 postgres.fm/episodes/not-v… 📺 youtu.be/X9bKbpGX2jw

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. 🎧 postgres.fm/episodes/reads… 📺 youtu.be/nhJhiga_tRY

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. 🎧 postgres.fm/episodes/retur… 📺 youtu.be/UrxKHNGgRSk

New episode: "SQL vs NoSQL" Nikolay and Michael are joined by Franck Pachot to discuss SQL vs NoSQL — did Franck change teams by joining MongoDB, normalisation vs denormalisation, developer experience, NULLs, and more! 🎧 postgres.fm/episodes/sql-v… 📺 youtu.be/bbYGgMQfB1U

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. 🎧 postgres.fm/episodes/exten… 📺 youtu.be/go7-RccYS2o

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. 🎧 postgres.fm/episodes/best-… 📺 youtu.be/eIYKYvnnrDo

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. 🎧 postgres.fm/episodes/gin-i… 📺 youtu.be/kG4qOkkx4qY

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. 🎧 postgres.fm/episodes/snaps… 📺 youtu.be/fbUlidlJzvA

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. 🎧 postgres.fm/episodes/pgdog 📺 youtu.be/PtKn3dqMKtQ

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. 🎧 postgres.fm/episodes/perfo… 📺 youtu.be/hyMHPN3EOpc

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. 🎧 postgres.fm/episodes/time-… 📺 youtu.be/nIfTwuyRI7k

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. 🎧 postgres.fm/episodes/manag… 📺 youtu.be/xpTNaih5pwo

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. 🎧 postgres.fm/episodes/synch… 📺 youtu.be/wKBGjbdrEvQ

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. 🎧 postgres.fm/episodes/top-t… 📺 youtu.be/cyaY8aYM3O8

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. 🎧 postgres.fm/episodes/locks 📺 youtu.be/LuhbMSvQ5c4

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. 🎧 postgres.fm/episodes/how-t… 📺 youtu.be/cI5skCTu3TQ

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. 🎧 postgres.fm/episodes/what-… 📺 youtu.be/FyY_xkDr9ts

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. 🎧 postgres.fm/episodes/mean-… 📺 youtu.be/ASwK4zPFzzo

New episode: "Multi-tenant options" Nikolay and Michael are joined by Gwen (Chen) Shapira to discuss multi-tenant architectures — the high level options, the pros and cons of each, and how they're trying to help with Nile. 🎧 postgres.fm/episodes/multi… 📺 youtu.be/1pb3qZyyR58