Podcast Episodes

Monitoring checklist

Episode 7

Monitoring checklist (dashboard 1):

TPS and (optional but also desired) QPSLatency (query duration) — at least average. Better: histogram, percentiles…

3 years, 11 months ago

View Episode

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 va…

4 years ago

View Episode

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…

4 years ago

View Episode

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…

4 years ago

View Episode

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…

4 years ago

View Episode

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 …

4 years, 1 month ago

View Episode

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 s…

4 years, 1 month ago

View Episode