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/writings/pgsql/hard.pdf

https://www.youtube.com/watch?v=2Nhbk1lFLy4

https://www.depesz.com/2020/09/08/waiting-for-postgresql-14-add-support-for-partitioned-tables-and-indexes-in-reindex/

https://pg.uptrace.dev/zfs/

https://postgresql.life/post/regina_obe/