Episode 172 Per-Operation Explain | PG14 Contributions | Foreign Parallel Execution | Incremental View Maintenance

<p>In this episode of Scaling Postgres, we discuss tracking per-operation explain analyze, Postgres 14 contribution stats, parallel execution on foreign servers and incremental view maintenance.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.pgmustard.com/blog/calculating-per-operation-times-in-postgres-explain-analyze"> https://www.pgmustard.com/blog/calculating-per-operation-times-in-postgres-explain-analyze</a><br /> <br /> <a href= "https://www.highgo.ca/2021/06/28/some-interesting-statistics-about-pg-14-contributions/"> https://www.highgo.ca/2021/06/28/some-interesting-statistics-about-pg-14-contributions/</a><br /> <br /> <a href= "https://www.highgo.ca/2021/06/28/parallel-execution-of-postgres_fdw-scans-in-pg-14-important-step-forward-for-horizontal-scaling/"> https://www.highgo.ca/2021/06/28/parallel-execution-of-postgres_fdw-scans-in-pg-14-important-step-forward-for-horizontal-scaling/</a><br /> <br /> <a href= "https://yugonagata-pgsql.blogspot.com/2021/06/implementing-incremental-view.html"> https://yugonagata-pgsql.blogspot.com/2021/06/implementing-incremental-view.html</a><br /> <br /> <a href= "https://lesovsky.medium.com/updates-of-postgresql-observability-diagram-66f0bbbfe021"> https://lesovsky.medium.com/updates-of-postgresql-observability-diagram-66f0bbbfe021</a><br /> <br /> <a href= "https://www.migops.com/blog/2021/07/01/ora2pg-now-supports-oracle_fdw-to-increase-the-data-migration-speed/"> https://www.migops.com/blog/2021/07/01/ora2pg-now-supports-oracle_fdw-to-increase-the-data-migration-speed/</a><br /> <br /> <a href= "http://postgis.net/2021/07/02/postgis-3.1.3/">http://postgis.net/2021/07/02/postgis-3.1.3/</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/postgis-setup-with-ubuntu-20-04-2/"> https://www.cybertec-postgresql.com/en/postgis-setup-with-ubuntu-20-04-2/</a><br /> <br /> <a href= "https://www.enterprisedb.com/blog/how-deploy-pgadmin-kubernetes">https://www.