Podcast Episodes
Back to SearchRails + 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, 1 month 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…
2 years, 1 month 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…
2 years, 1 month 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 …
2 years, 2 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…
2 years, 2 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…
2 years, 2 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, 2 months ago
EXPLAIN
Episode 79
With Nikolay taking a well-earned break, Michael covers the basics of EXPLAIN — what it is, the parameters available, and a process he recommends for…
2 years, 2 months ago
work_mem
Episode 78
Happy holidays! Today's topic is work_mem — how it's used and how to tune it.
Related post: https://x.com/samokhvalov/status/1740813478150189172?s=46…
2 years, 3 months ago
Partitioning by ULID
Episode 77
Nikolay and Michael discuss partitioning by ULID — revisiting some of the old UUID vs bigint key debate in light of some new UUID specs, and how thes…
2 years, 3 months ago