Podcast Episodes

Stored procedures

Episode 16

Here are links to a few things we mentioned: 

Extending SQL PostgREST  PL/pgSQL EdgeDB  pgTAP  Sqitch Flyway  Liquibase  client_min_messages  log_min_…

3 years, 5 months ago

View Episode

PostgreSQL 15

Episode 15

Here are links to a few things we mentioned: 

PostgreSQL 15 release notesSpeeding up sort performance in Postgres 15 (blog post by David Rowley)Past, …

3 years, 5 months ago

View Episode

102 Query optimization

Episode 14

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

3 years, 5 months ago

View Episode

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…

3 years, 6 months 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…

3 years, 6 months 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…

3 years, 6 months 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…

3 years, 6 months 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…

3 years, 7 months 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…

3 years, 7 months 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…

3 years, 7 months ago

View Episode