Slow Archival, Index Improvements, Node Metrics, Join or Subquery | Scaling Postgres 131
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/
Create your
podcast in
minutes
It is Free