Podcast Episodes
Back to SearchEXPLAIN
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 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 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 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, 1 month 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, 1 month 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, 1 month ago
Subtransactions
Episode 73
Nikolay and Michael discuss PostgreSQL subtransactions — what they are, and four issues they can cause at scale.
Here are some links to things they …
2 years, 1 month ago
Companion databases
Episode 72
Nikolay and Michael discuss companion databases — when and why you might want to add another database management system to your stack (or not), and s…
2 years, 2 months ago
Blue-green deployments
Episode 71
Nikolay and Michael discuss blue-green deployments — specifically an RDS blog post, how similar this is (or not) to what they understand to be blue-g…
2 years, 2 months ago
Data model trade-offs
Episode 70
Nikolay and Michael discuss data model trade-offs — some cases where you might want to (gasp) de-normalize, and which PostgreSQL internals are at pla…
2 years, 2 months ago