Podcast Episodes
Back to SearchArchiving
Episode 167
Nik and Michael discuss a listener question about archiving a database.
Here are some links to things they mentioned:
7 months, 3 weeks ago
max_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 …
8 months, 1 week 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:
8 months, 3 weeks 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…
9 months 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…
9 months, 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 resource…
9 months, 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…
10 months, 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 …
10 months, 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 g…
10 months, 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 …
11 months ago