Episode 214 Backup Compression, Postgres IO, Parquet Files, pg_stat_monitor

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "http://rhaas.blogspot.com/2022/05/parallel-server-side-backup-compression.html"> http://rhaas.blogspot.com/2022/05/parallel-server-side-backup-compression.html</a></li> <li><a href= "https://www.youtube.com/watch?v=3Oj7fBAqVTw">https://www.youtube.com/watch?v=3Oj7fBAqVTw</a></li> <li><a href= "https://www.crunchydata.com/blog/parquet-and-postgres-in-the-data-lake"> https://www.crunchydata.com/blog/parquet-and-postgres-in-the-data-lake</a></li> <li><a href= "https://www.percona.com/blog/understand-your-postgresql-workloads-better-with-pg_stat_monitor/"> https://www.percona.com/blog/understand-your-postgresql-workloads-better-with-pg_stat_monitor/</a></li> <li><a href= "https://www.timescale.com/blog/point-in-time/">https://www.timescale.com/blog/point-in-time/</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/postgresql-15-using-merge-in-sql/"> https://www.cybertec-postgresql.com/en/postgresql-15-using-merge-in-sql/</a></li> <li><a href= "https://www.highgo.ca/2022/04/30/upcoming-feature-in-postgresql-15-merge-statement/"> https://www.highgo.ca/2022/04/30/upcoming-feature-in-postgresql-15-merge-statement/</a></li> <li><a href= "https://andreas.scherbaum.la/blog/archives/1110-Its-beer-oclock-for-PostgreSQL.html"> https://andreas.scherbaum.la/blog/archives/1110-Its-beer-oclock-for-PostgreSQL.html</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-15-beta1-incremental-materialized-views-pg-ivm"> https://pganalyze.com/blog/5mins-postgres-15-beta1-incremental-materialized-views-pg-ivm</a></li> <li><a href= "https://www.highgo.ca/2022/05/06/atomic-commit-with-2-phase-commit-in-fdw-distributed-setup/"> https://www.highgo.ca/2022/05/06/atomic-commit-with-2-phase-commit-in-fdw-distributed-setup/</a></li