Postgres FM

A weekly podcast about all things PostgreSQL

134 episodes transcribed
0 comments
Technology

102 Query optimization

Episode Date: October 7, 2022

Here are links to a few things we mentioned: pg_plan_advsr How partial, covering, and multicolumn indexes may slow down UPDATEs (blog post by...

0 comments
Technology

Index maintenance

Episode Date: September 23, 2022

Important correction from this episode: amcheck promises no false positives, not no false negatives, sorry!Here are links to a few things we...

0 comments
Technology

How to become a DBA

Episode Date: August 26, 2022

And few things we mentioned: Topic request on Reddit — thanks HerbyHoover!Haki Benita's blog PostgreSQL documentation (table of contents) Pla...

0 comments
Technology

Monitoring checklist

Episode Date: August 19, 2022

Monitoring checklist (dashboard 1):TPS and (optional but also desired) QPSLatency (query duration) — at least average. Better: histogram, per...

0 comments
Technology

Vacuum

Episode Date: August 12, 2022

Here are links to a few things we mentioned: Do you vacuum everyday? (talk by Hannu Krosing)Autovacuum tuning (EDB guide) When autovacuum doe...

0 comments
Technology

BUFFERS by default

Episode Date: July 29, 2022

Here are links to a few things we mentioned: EXPLAIN parameters (PostgreSQL documentation)EXPLAIN (ANALYZE) needs BUFFERS (blog post by Nikol...

0 comments
Technology

BRIN indexes

Episode Date: July 21, 2022

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 impr...