Podcast Episodes

Soft delete

Episode 103

Nikolay and Michael discuss soft deletion in Postgres — what it means, several use cases, some implementation options, and which implementations suit…

2 years, 3 months ago

View Episode

Should we use foreign keys?

Episode 102

Nikolay and Michael discuss foreign keys in Postgres — what they are, their benefits, their overhead, some edge cases to be aware of, some improvemen…

2 years, 4 months ago

View Episode

pgvectorscale

Episode 101

Nikolay is joined by Mat Arye and John Pruitt, from Timescale, to discuss their new extension pgvectorscale and high-performance vector search in Pos…

2 years, 4 months ago

View Episode

To 100TB, and beyond!

Episode 100

Michael and Nikolay are joined by three special guests for episode 100 who have all scaled Postgres to significant scale — Arka Ganguli from Notion, …

2 years, 4 months ago

View Episode

Sponsoring the community

Episode 99

Michael is joined by Claire Giordano, Head of Postgres Open Source Community Initiatives at Microsoft, to discuss several ways to contribute to the P…

2 years, 4 months ago

View Episode

Full text search

Episode 98

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 to replac…

2 years, 5 months ago

View Episode

Minor releases

Episode 97

Nikolay and Michael discuss Postgres minor releases — how the schedule works, options for upgrading to them, and the importance of reading the releas…

2 years, 5 months ago

View Episode

Custom vs generic plan

Episode 96

Nikolay and Michael discuss custom and generic planning in prepared statements — how it works, how issues can present themselves, some ways to view t…

2 years, 5 months ago

View Episode

LIMIT vs Performance

Episode 95

Nikolay and Michael discuss LIMIT in Postgres — what it does, how it can help with performance, and an interesting example where adding it can actual…

2 years, 5 months ago

View Episode

Buffers II (the sequel)

Episode 94

Nikolay and Michael return to the topic of using the buffers explain parameter — with a new analogy, some (conspiracy) theories of why it's still not…

2 years, 5 months ago

View Episode