Podcast Episodes
Back to SearchHealth 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…
1 year, 9 months 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…
1 year, 10 months 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…
1 year, 10 months ago
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 —…
1 year, 10 months ago
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…
1 year, 10 months ago
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…
1 year, 11 months ago
Modern SQL
Episode 83
Michael is joined by Markus Winand, creator of use-the-index-luke.com and modern-sql.com, and author of SQL Performance Explained, to discuss Modern …
1 year, 11 months ago
Bloat
Episode 82
Michael is joined by Chelsea Dole, Staff Software Engineer and Tech Lead of the Data Storage Team at Brex, to discuss bloat. They cover what it is, w…
1 year, 11 months ago
pgvector
Episode 81
Michael is joined by Jonathan Katz, PostgreSQL Core Team member, Principle Product Manager at AWS, and also pgvector contributor, to discuss pgvector…
1 year, 11 months ago
pgBadger
Episode 80
Michael is joined by Alicja Kucharczyk, Program Manager for Azure Database for PostgreSQL at Microsoft and organiser of the Warsaw PostgreSQL User Gr…
2 years ago