A weekly podcast about all things PostgreSQL
134 episodes transcribedNikolay and Michael discuss why counting can be slow in Postgres, and what the options are for counting things quickly at scale. Here are som...
Michael and Nikolay are joined by Peter Geoghegan, major contributor and committer to Postgres, to discuss adding skip scan support to Postgr...
Nikolay and Michael discuss PostgreSQL emergencies — both the psychological side of incident management, and some technical aspects too. Here...
Michael and Nikolay are joined by Haki Benita, a technical lead and database enthusiast who writes an excellent blog and gives popular talks...
Michael and Nikolay are joined by Melanie Plageman, database internals engineer at Microsoft and major contributor and committer to PostgreSQ...
Nikolay and Michael discuss Index-Only Scans in Postgres — what they are, how they help, some things to look out for, and some advice. Here a...
Nikolay and Michael discuss why they chose Postgres — as users, for their businesses, for their careers, as well as some doubts. Here are som...
Nikolay and Michael discuss compression in Postgres — what's available natively, newer algorithms in recent versions, and several extensions...
Nikolay and Michael discuss Postgres running out of disk space — including what happens, what can cause it, how to recover, and most importan...
Nikolay and Michael discuss the Postgres startup ecosystem — some recent closures, some recent fundraising announcements, and their thoughts...
Nikolay talks Michael through a recent experiment to find the current maximum transactions per second single-node Postgres can achieve — why...
Nikolay and Michael discuss soft deletion in Postgres — what it means, several use cases, some implementation options, and which implementati...
Nikolay and Michael discuss foreign keys in Postgres — what they are, their benefits, their overhead, some edge cases to be aware of, some im...
Nikolay is joined by Mat Arye and John Pruitt, from Timescale, to discuss their new extension pgvectorscale and high-performance vector searc...
Michael and Nikolay are joined by three special guests for episode 100 who have all scaled Postgres to significant scale — Arka Ganguli from...
Michael is joined by Claire Giordano, Head of Postgres Open Source Community Initiatives at Microsoft, to discuss several ways to contribute...
Nikolay and Michael discuss full text search in Postgres — some of the history, some of the features, and whether it now makes sense to try t...
Nikolay and Michael discuss Postgres minor releases — how the schedule works, options for upgrading to them, and the importance of reading th...
Nikolay and Michael discuss custom and generic planning in prepared statements — how it works, how issues can present themselves, some ways t...
Nikolay and Michael discuss LIMIT in Postgres — what it does, how it can help with performance, and an interesting example where adding it ca...
