Podcast Episodes

Why is Postgres popular?

Episode 13

This episode was badly affected by internet issues. Hopefully the edit came out ok, but the quality should be back to a better level from next week.

H…

4 years ago

View Episode

Index maintenance

Episode 12

Important correction from this episode: amcheck promises no false positives, not no false negatives, sorry!

Here are links to a few things we mentione…

4 years, 1 month ago

View Episode

Query macro analysis intro

Episode 11

Here are links to a few things we mentioned: 

pg_stat_statementspgFouinepgBadgerpg_querypg_stat_activityauto_explainCan auto_explain (with timing) hav…

4 years, 1 month ago

View Episode

WAL and checkpoint tuning

Episode 10

Here are links to a few things we mentioned: 

LSN (log sequence number)On the impact of full-page writes (blog post by Tomas Vondra)Deep dive on Auror…

4 years, 1 month ago

View Episode

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…

4 years, 1 month ago

View Episode

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…

4 years, 1 month ago

View Episode

Monitoring checklist

Episode 7

Monitoring checklist (dashboard 1):

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

4 years, 2 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, 2 months 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, 2 months 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, 2 months ago

View Episode