Podcast Episodes
Back to SearchHigh availability
Episode 56
Nikolay and Michael discuss HA (high availability) — what it means, tools and techniques for maximising it, while going through some of the more comm…
2 years, 8 months ago
Beginner tips
Episode 55
Nikolay and Michael discuss 10 beginner tips Nikolay recently shared — they go into a bit more detail on each, and even disagree a little on one or t…
2 years, 8 months ago
Connection poolers
Episode 54
Nikolay and Michael discuss Postgres connection poolers — when and why we need them, the king that is PgBouncer, and the many new pretenders to the t…
2 years, 8 months ago
Anniversary 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…
2 years, 8 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…
2 years, 9 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…2 years, 9 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 …
2 years, 9 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…
2 years, 9 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…
2 years, 10 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:
2 years, 10 months ago