Scaling Postgres

In this episode of Scaling Postgres, we discuss slow WAL archival, index improvements coming for Postgres 13, accessing node metrics via SQL and deciding between a join or subquery. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.percona.com/blog/2020/09/09/why-postgresql-wal-archival-is-slow/ https://www.percona.com/blog/2020/09/10/index-improvements-in-postgresql-13/ https://blog.rustprooflabs.com/2020/09/postgres-beta3-btree-dedup https://info.crunchydata.com/blog/postgresql-node-metrics-pgnodemx https://info.crunchydata.com/blog/joins-or-subquery-in-postgresql-lessons-learned https://www.cybertec-postgresql.com/en/generating-a-normal-distribution-in-sql/ https://www.2ndquadrant.com/en/blog/which-partition-contains-a-specific-row-in-my-postgresql-database/ https://blog.hagander.net/fdws-curl-and-limit-247/ https://www.2ndquadrant.com/en/blog/pg-phriday-10-things-postgres-could-improve-part-3/ https://momjian.us/main