Podcast Episodes
Back to SearchCustom vs generic plan
Episode 96
Nikolay and Michael discuss custom and generic planning in prepared statements — how it works, how issues can present themselves, some ways to view t…
1 year, 10 months ago
LIMIT vs Performance
Episode 95
Nikolay and Michael discuss LIMIT in Postgres — what it does, how it can help with performance, and an interesting example where adding it can actual…
1 year, 11 months ago
Buffers II (the sequel)
Episode 94
Nikolay and Michael return to the topic of using the buffers explain parameter — with a new analogy, some (conspiracy) theories of why it's still not…
1 year, 11 months ago
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 …
1 year, 11 months ago
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…
1 year, 11 months ago
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…
1 year, 11 months ago
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 ago
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 ago
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 ago
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 ago