Podcast Episodes
Back to SearchGapless 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 yo…
11 months, 3 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 resource…
1 year 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…
1 year 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 …
1 year 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 g…
1 year, 1 month 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 …
1 year, 1 month 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 l…
1 year, 1 month 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 …
1 year, 1 month 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.
H…
1 year, 2 months ago
Self-driving Postgres
Episode 154
Nikolay and Michael discuss self-driving Postgres — what it could mean, using self-driving cars as a reference, and ideas for things to build and opt…
1 year, 2 months ago