Search

Home > Scaling Postgres > Episode 131 Slow Archival | Index Improvements | Node Metrics | Join or Subquery
Podcast: Scaling Postgres
Episode:

Episode 131 Slow Archival | Index Improvements | Node Metrics | Join or Subquery
Category: Technology
Duration: 00:15:59
Publish Date: 2020-09-13 23:49:09
Description:

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/
Total Play: 0