Podcast Episodes
Back to SearchSelf-managing
Episode 59
Nikolay and Michael discuss self-managing Postgres — both the practicalities of doing so, as well as some managed-service style tooling.
Here are so…
2 years, 4 months ago
Sharding
Episode 58
Nikolay and Michael discuss sharding Postgres — what it means, why and when it's needed, and the available options right now.
Here are some links to…
2 years, 5 months ago
Data types
Episode 57
Nikolay and Michael discuss data types in PostgreSQL — including system types, choosing between types, types provided by extensions, and more.
Here …
2 years, 5 months 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…
2 years, 5 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, 5 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, 6 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, 6 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, 6 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, 6 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, 7 months ago