Podcast Episodes
Back to Searchmax_connections vs migrations
Episode 166
Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!)
Here …
3 months, 4 weeks ago
What's new in EXPLAIN
Episode 165
Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18.
Here are some links to things they mentioned:
4 months, 1 week ago
Tens 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…
4 months, 2 weeks 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 yo…
5 months 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…
5 months, 2 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…
6 months 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 …
6 months, 1 week 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…
6 months, 2 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 …
6 months, 3 weeks 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…
6 months, 4 weeks ago