Podcast Episodes
Back to SearchModern SQL
Episode 83
Michael is joined by Markus Winand, creator of use-the-index-luke.com and modern-sql.com, and author of SQL Performance Explained, to discuss Modern …
2 years, 8 months ago
Bloat
Episode 82
Michael is joined by Chelsea Dole, Staff Software Engineer and Tech Lead of the Data Storage Team at Brex, to discuss bloat. They cover what it is, w…
2 years, 8 months ago
pgvector
Episode 81
Michael is joined by Jonathan Katz, PostgreSQL Core Team member, Principle Product Manager at AWS, and also pgvector contributor, to discuss pgvector…
2 years, 9 months ago
pgBadger
Episode 80
Michael is joined by Alicja Kucharczyk, Program Manager for Azure Database for PostgreSQL at Microsoft and organiser of the Warsaw PostgreSQL User Gr…
2 years, 9 months ago
EXPLAIN
Episode 79
With Nikolay taking a well-earned break, Michael covers the basics of EXPLAIN — what it is, the parameters available, and a process he recommends for…
2 years, 9 months ago
work_mem
Episode 78
Happy holidays! Today's topic is work_mem — how it's used and how to tune it.
Related post: https://x.com/samokhvalov/status/1740813478150189172?s=46…
2 years, 9 months ago
Partitioning by ULID
Episode 77
Nikolay and Michael discuss partitioning by ULID — revisiting some of the old UUID vs bigint key debate in light of some new UUID specs, and how thes…
2 years, 10 months ago
Hash indexes
Episode 76
Nikolay and Michael discuss hash indexes in Postgres — what they are, some brief history, their pros and cons vs btrees, and whether or when they rec…
2 years, 10 months ago
Constraints
Episode 75
Nikolay and Michael discuss PostgreSQL constraints — the six different types we have, how to add and modify them, including on large tables with high…
2 years, 10 months ago
Events
Episode 74
Nikolay and Michael discuss PostgreSQL events — whether in-person or online, large conferences or small meet-ups, as well as some strong opinions bas…
2 years, 10 months ago