Podcast Episodes
Back to SearchAnniversary mailbag
Episode 53
Nikolay and Michael celebrate the podcast's 1 year anniversary by going through several questions and suggestions received over the year.
Here are th…
3 years, 3 months ago
pg_upgrade: the tricky and dangerous parts
Episode 52
Nikolay (alone, again) reveals some issues that might hit those who perform major PostgreSQL upgrades with minimal downtime.
Links:
- "Upgrades" – Post…
3 years, 3 months ago
UUID
Episode 51
Lonely Nikolay discusses the performance aspects of using UUID for primary keys.
Here are links to a few things I mentioned:
"postgresql" posts on HN…3 years, 4 months ago
Memory
Episode 50
Nikolay and Michael discuss memory in PostgreSQL — how it works, important settings, and how to go about tuning them.
Here are links to a few things …
3 years, 4 months ago
Extensions
Episode 49
Nikolay and Michael discuss Postgres extensions — what they are, how they affect your decisions around Postgres, and some things to keep in mind when…
3 years, 4 months ago
Zero-downtime migrations
Episode 48
Nikolay and Michael discuss zero-downtime schema migrations — why they're a challenge, a variety of different cases, and some things you can do to ac…
3 years, 4 months ago
Parallelism
Episode 47
Nikolay and Michael discuss parallelism — both parallel query execution and other parallel operations.
Here are links to a few things we mentioned:
3 years, 4 months ago
Corruption
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…
3 years, 5 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 …
3 years, 5 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:
3 years, 5 months ago