Episode 131 Slow Archival | Index Improvements | Node Metrics | Join or Subquery

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.percona.com/blog/2020/09/09/why-postgresql-wal-archival-is-slow/"> https://www.percona.com/blog/2020/09/09/why-postgresql-wal-archival-is-slow/</a><br /> <br /> <a href= "https://www.percona.com/blog/2020/09/10/index-improvements-in-postgresql-13/"> https://www.percona.com/blog/2020/09/10/index-improvements-in-postgresql-13/</a><br /> <br /> <a href= "https://blog.rustprooflabs.com/2020/09/postgres-beta3-btree-dedup"> https://blog.rustprooflabs.com/2020/09/postgres-beta3-btree-dedup</a><br /> <br /> <a href= "https://info.crunchydata.com/blog/postgresql-node-metrics-pgnodemx"> https://info.crunchydata.com/blog/postgresql-node-metrics-pgnodemx</a><br /> <br /> <a href= "https://info.crunchydata.com/blog/joins-or-subquery-in-postgresql-lessons-learned"> https://info.crunchydata.com/blog/joins-or-subquery-in-postgresql-lessons-learned</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/generating-a-normal-distribution-in-sql/"> https://www.cybertec-postgresql.com/en/generating-a-normal-distribution-in-sql/</a><br /> <br /> <a href= "https://www.2ndquadrant.com/en/blog/which-partition-contains-a-specific-row-in-my-postgresql-database/"> https://www.2ndquadrant.com/en/blog/which-partition-contains-a-specific-row-in-my-postgresql-database/</a><br /> <br /> <a href= "https://blog.hagander.net/fdws-curl-and-limit-247/">https://blog.hagander.net/fdws-curl-and-limit-247/</a><br /> <br /> <a href= "https://www.2ndquadrant.com/en/blog/pg-phriday-10-things-postgres-could-improve-part-3/"> https://www.2ndquadrant.com/en/blog/pg-phriday-10-things-postgres-could-improve-part-3/</a><br /> <br /> <a href= "https://momjian.us/main/writings/pgsql/hard.pdf">https://momjian.us/main/writin