Scaling Postgres

In this episode of Scaling Postgres, we discuss 28 tips & tricks, Postgres 13 is lucky, autovacuum tuning and logical replication pitfalls. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://pgdash.io/blog/postgres-tips-and-tricks.html https://info.crunchydata.com/blog/why-postgresql-13-is-a-lucky-release https://www.cybertec-postgresql.com/en/tuning-autovacuum-postgresql/ https://elephanttamer.net/?p=35 https://www.youtube.com/watch?v=eDkwqAZ-rpk https://b-peng.blogspot.com/2020/08/authentication-in-pgpool.html https://info.crunchydata.com/blog/using-postgres-to-back-prometheus-for-your-postgresql-monitoring-1 https://www.highgo.ca/2020/08/28/who-is-spending-wal-crazily/ https://www.2ndquadrant.com/en/blog/advanced-partition-matching-for-partition-wise-join/ https://www.depesz.com/2020/08/24/waiting-for-postgresql-14-pg_stat_statements-track-number-of-rows-processed-by-some-utility-commands/ https://info.crunchydata.com/b