Podcast Episodes

Massive DELETEs

Episode 93

Nikolay and Michael discuss doing massive DELETE operations in Postgres — what can go wrong, how to prevent major issues, and some ideas to minimise …

2 years, 6 months ago

View Episode

Logical replication common issues

Episode 92

Nikolay and Michael are joined by Sai Srirampur, CEO and Co-founder of PeerDB, to discuss how to overcome several logical replication issues. They di…

2 years, 6 months ago

View Episode

Don't do this

Episode 91

Nikolay and Michael discuss several "Don't do this" lists about Postgres — picking out their favourite items, as well as some contentious ones that c…

2 years, 6 months ago

View Episode

Search

Episode 90

Nikolay and Michael have a high-level discussion on all things search — touching on full-text search, semantic search, and faceted search. They discu…

2 years, 6 months ago

View Episode

Health check

Episode 89

Nikolay and Michael discuss Postgres health checks — what they are, things to include, how often makes sense, and whether improvements to Postgres wo…

2 years, 7 months ago

View Episode

superuser

Episode 88

Nikolay and Michael discuss the superuser role in PostgreSQL — what it is, how and when it shouldn’t be used, and whether most cloud providers are ri…

2 years, 7 months ago

View Episode

transaction_timeout

Episode 87

Nikolay and Michael discuss transaction_timeout (a recently committed addition for Postgres 17) — what it's for, how to get around not having it alre…

2 years, 7 months ago

View Episode

Rails + Postgres

Episode 86

Michael and Nikolay are joined by Andrew Atkinson, author of High Performance PostgreSQL for Rails, to discuss how Rails and Postgres work together —…

2 years, 7 months ago

View Episode

Why isn't Postgres using my index?

Episode 85

Nikolay and Michael discuss a common question — why Postgres isn't using an index, and what you can do about it!
 
Here are some links to things they m…

2 years, 8 months ago

View Episode

Overhead of pg_stat_statements and pg_stat_kcache

Episode 84

Nikolay and Michael discuss the overhead of pg_stat_statements and pg_stat_kcache — mostly focusing on some interesting things Nikolay found while st…

2 years, 8 months ago

View Episode