Podcast Episodes
Back to SearchExtensions
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, 7 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, 7 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, 7 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…
2 years, 7 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, 8 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, 8 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, 8 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, 8 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, 9 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, 9 months ago