Podcast Episodes
Back to SearchIntro to query optimization
Episode 9
Here are links to a few things we mentioned:
Using EXPLAIN (PostgreSQL documentation)explain.depesz.comexplain.dalibo.compgMustard EverSQLpganalyzepg…3 years, 4 months 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 Post…3 years, 4 months ago
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, 4 months 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 va…3 years, 5 months 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…3 years, 5 months 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…3 years, 5 months 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…3 years, 5 months 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 …
3 years, 6 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 s…
3 years, 6 months ago