Podcast Episodes
Back to SearchData types
Episode 57
Nikolay and Michael discuss data types in PostgreSQL — including system types, choosing between types, types provided by extensions, and more.
Here …
3 years ago
High 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…
3 years 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…
3 years 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…
3 years, 1 month 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…
3 years, 1 month 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, 1 month 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, 1 month 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, 1 month 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, 2 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, 2 months ago