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/