In this episode of Scaling Postgres, we discuss parallel server-side backup compression, IO in Postgres, parquet files and the new pg_stat_monitor extension.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

  • http://rhaas.blogspot.com/2022/05/parallel-server-side-backup-compression.html
  • https://www.youtube.com/watch?v=3Oj7fBAqVTw
  • https://www.crunchydata.com/blog/parquet-and-postgres-in-the-data-lake
  • https://www.percona.com/blog/understand-your-postgresql-workloads-better-with-pg_stat_monitor/
  • https://www.timescale.com/blog/point-in-time/
  • https://www.cybertec-postgresql.com/en/postgresql-15-using-merge-in-sql/
  • https://www.highgo.ca/2022/04/30/upcoming-feature-in-postgresql-15-merge-statement/
  • https://andreas.scherbaum.la/blog/archives/1110-Its-beer-oclock-for-PostgreSQL.html
  • https://pganalyze.com/blog/5mins-postgres-15-beta1-incremental-materialized-views-pg-ivm
  • https://www.highgo.ca/2022/05/06/atomic-commit-with-2-phase-commit-in-fdw-distributed-setup/
  • https://postgresql.life/post/abbas_butt/
  • https://www.rubberduckdevshow.com/episodes/41-the-jira-incident/