Podcast Episodes
Back to SearchHash 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, 3 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, 3 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, 4 months 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, 4 months 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, 4 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, 4 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, 5 months ago
Under-indexing
Episode 69
Nikolay and Michael discuss under-indexing — how to tell if this applies to you, some general and specific cases, as well as some tricky ones.
Here …
2 years, 5 months ago
Over-indexing
Episode 68
Nikolay and Michael discuss over-indexing — what we mean by it, the regular issues people discuss about it, as well as a novel one Nikolay has come a…
2 years, 5 months ago
Query hints
Episode 67
Nikolay and Michael discuss query hints — what they are, what we do and don't have in PostgreSQL, and some other things in and around the ecosystem t…
2 years, 5 months ago