Podcast Episodes
Back to SearchIndex-Only Scans
Episode 109
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 are some …
1 year, 5 months ago
Why Postgres?
Episode 108
Nikolay and Michael discuss why they chose Postgres — as users, for their businesses, for their careers, as well as some doubts.
Here are some links …
1 year, 5 months ago
Compression
Episode 107
Nikolay and Michael discuss compression in Postgres — what's available natively, newer algorithms in recent versions, and several extensions with com…
1 year, 5 months ago
Out of disk
Episode 106
Nikolay and Michael discuss Postgres running out of disk space — including what happens, what can cause it, how to recover, and most importantly, how…
1 year, 5 months ago
Postgres startup ecosystem
Episode 105
Nikolay and Michael discuss the Postgres startup ecosystem — some recent closures, some recent fundraising announcements, and their thoughts on where…
1 year, 6 months ago
Four million TPS
Episode 104
Nikolay talks Michael through a recent experiment to find the current maximum transactions per second single-node Postgres can achieve — why he was l…
1 year, 6 months ago
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…
1 year, 6 months ago
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…
1 year, 6 months ago
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…
1 year, 7 months ago
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, …
1 year, 7 months ago