Podcast Episodes
Back to SearchRegreSQL
Episode 169
Nik and Michael are joined by Radim Marek from boringSQL to talk about RegreSQL, a regression testing tool for SQL queries they forked and improved r…
19 hours ago
Postgres year in review 2025
Episode 168
Nik and Michael discuss the events and trends they thought were most important in the Postgres ecosystem in 2025.
Here are some links to things they …
2 weeks ago
Archiving
Episode 167
Nik and Michael discuss a listener question about archiving a database.
Here are some links to things they mentioned:
4 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 …
1 month, 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:
1 month, 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…
2 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…
2 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…
2 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…
3 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 …
3 months, 3 weeks ago