Podcast Episodes
Back to SearchCorruption
Episode 46
Nikolay and Michael discuss database corruption — various types, how they can come about, and what to do (and not do) if you come across it.
Here ar…
2 years, 10 months ago
ChatGPT x PostgreSQL
Episode 45
Nikolay and Michael discuss using ChatGPT for Postgres tasks — should you, if so what for, and some things to be mindful of!
Here are links to a few …
2 years, 10 months ago
pg_stat_statements
Episode 44
Nikolay and Michael discuss pg_stat_statements — why everyone should use it, but also some downsides!
Here are links to a few things we mentioned:
2 years, 10 months ago
auto_explain
Episode 43
Nikolay and Michael discuss auto_explain — what it is, how it can help, and how to check it's overhead.
Here are links to a few things we mentioned: …
2 years, 11 months ago
Queues in Postgres
Episode 42
Nikolay and Michael discuss queues in Postgres — the pros and cons vs dedicated queuing tools, and some tips for scaling.
A couple of apologies-in-ad…
2 years, 11 months ago
Read-only considerations
Episode 41
Nikolay and Michael discuss a listener request — special considerations for databases that are used in a read-only mode all day, and get an update at…
2 years, 11 months ago
Partitioning
Episode 40
Nikolay and Michael discuss table partitioning — what it is, why and when it's helpful, and some considerations for your partition key.
Here are link…
2 years, 11 months ago
Peter Zaitsev
Episode 39
This week we're sharing an edited version of Nikolay's recent interview with Peter Zaitsev from Percona — they discuss MySQL vs Postgres, Percona’s s…
3 years ago
psql vs GUIs
Episode 38
Nikolay and Michael discuss command line and graphical user interfaces for Postgres — what they are, some tips and tricks for learning, and what we e…
3 years ago
Upgrades
Episode 37
Nikolay and Michael discuss major and minor version Postgres upgrades — what they are, how often they come out, and how regularly we should be upgrad…
3 years ago