Podcast Episodes
Back to SearchTens of TB per hour
Episode 164
Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica.
Here are some links to things they mentioned:
Published on 8 hours ago
Gapless sequences
Episode 163
Nik and Michael discuss the concept of gapless sequences — when you might want one, why sequences in Postgres can have gaps, and an idea or two if you do want them.
And one quick clarification: changi…
Published on 2 weeks ago
LWLocks
Episode 162
Nik and Michael discuss lightweight locks in Postgres — how they differ to (heavier) locks, some occasions they can be troublesome, and some resources for working out what to do if you hit issues.
He…
Published on 4 weeks ago
User management
Episode 161
Nik and Michael discuss user management in Postgres — how roles work, making administration easier, setting passwords, and avoiding them being logged.
Here are some links to things they mentioned:
Published on 1 month, 1 week ago
Postgres 18
Episode 160
Nik and Michael discuss the newly released Postgres 18 — the bigger things it includes, some of their personal highlights, and some thoughts towards the future.
Here are some links to things they men…
Published on 1 month, 2 weeks ago
Gadget's use of Postgres
Episode 159
Nik and Michael are joined by Harry Brundage from Gadget to talk about their recent zero-downtime major version upgrade, how they use Postgres more generally, their dream database, and some challenge…
Published on 1 month, 3 weeks ago
turbopuffer
Episode 158
Nik and Michael are joined by Simon Eskildsen from turbopuffer — among other things, they discuss ANN index types, tradeoffs that can make sense for search workloads, and when it can make sense to mo…
Published on 2 months ago
When not to use Postgres
Episode 157
Nik and Michael discuss when not to use Postgres — specifically use cases where it still makes sense to store data in another system.
Here are some links to things they mentioned:
Published on 2 months, 1 week ago
Disks
Episode 156
Nik and Michael discuss disks in relation to Postgres — why they matter, how saturation can happen, some modern nuances, and how to prepare to avoid issues.
Here are some links to things they mention…
Published on 2 months, 2 weeks ago
Multi-column indexes
Episode 155
Nik and Michael discuss multi-column indexes in Postgres — what they are, how to think about them, and some guidance around using them effectively.
Here are some links to things they mentioned:
Published on 2 months, 3 weeks ago