Podcast Episodes

Intro to query optimization

---

Episode 9

---

Here are links to a few things we mentioned: 

Using EXPLAIN (PostgreSQL documentation)explain.depesz.comexplain.dalibo.compgMustard EverSQLpganalyzepg_stat_monitor (Extension by Percona)Recent thread …

---

Published on 3 years ago

How to become a DBA

---

Episode 8

---

And few things we mentioned: 

Topic request on Reddit — thanks HerbyHoover!Haki Benita's blog PostgreSQL documentation (table of contents) Planet PostgreSQL (blog aggregator) MVCC Unmasked (by Bruce M…

---

Published on 3 years ago

Monitoring checklist

---

Episode 7

---

Monitoring checklist (dashboard 1):

TPS and (optional but also desired) QPSLatency (query duration) — at least average. Better: histogram, percentilesConnections (sessions) — stacked graph of session …

---

Published on 3 years, 1 month ago

Vacuum

---

Episode 6

---

Here are links to a few things we mentioned: 

Do you vacuum everyday? (talk by Hannu Krosing)Autovacuum tuning (EDB guide) When autovacuum does not vacuum (2ndQuadrant blog post by Tomas Vondra) Autov…

---

Published on 3 years, 1 month ago

NULLs: the good, the bad, the ugly, and the unknown

---

Episode 5

---

Here are links to a few things we mentioned: 

Three-valued_logic (Wikipedia)Postgres 15 improves UNIQUE and NULL (blog post by Ryan Lambert) Practical SQL for Data Analysis — Interpolation (blog post …

---

Published on 3 years, 1 month ago

BUFFERS by default

---

Episode 4

---

Here are links to a few things we mentioned: 

EXPLAIN parameters (PostgreSQL documentation)EXPLAIN (ANALYZE) needs BUFFERS (blog post by Nikolay)Using BUFFERS for query optimization (blog post by Mich…

---

Published on 3 years, 1 month ago

BRIN indexes

---

Episode 3

---

Here are links to the two main resources we mentioned: 

Paul Ramsey's recent blog post on BRIN indexesTomas Vondra's slides on BRIN index improvements

A few other things we mentioned:

B-tree Wikipedia p…

---

Published on 3 years, 1 month ago

Managed services vs. DIY

---

Episode 2

---

A well as discussing pros and cons, we mentioned a LOT of different providers and tools, and a few good articles/videos too. 😅

Here are links to most of them, roughly in the order they came up: 

How Au…

---

Published on 3 years, 2 months ago

Slow queries and slow transactions

---

Episode 1

---

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides

If you would like to share this episode, here's a good link (and thank y…

---

Published on 3 years, 2 months ago