Scaling Postgres

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. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.pgmustard.com/blog/calculating-per-operation-times-in-postgres-explain-analyze https://www.highgo.ca/2021/06/28/some-interesting-statistics-about-pg-14-contributions/ https://www.highgo.ca/2021/06/28/parallel-execution-of-postgres_fdw-scans-in-pg-14-important-step-forward-for-horizontal-scaling/ https://yugonagata-pgsql.blogspot.com/2021/06/implementing-incremental-view.html https://lesovsky.medium.com/updates-of-postgresql-observability-diagram-66f0bbbfe021 https://www.migops.com/blog/2021/07/01/ora2pg-now-supports-oracle_fdw-to-increase-the-data-migration-speed/ http://postgis.net/2021/07/02/postgis-3.1.3/ https://www.cybertec-postgresql.com/en/postgis-setup-with-ubuntu-20-04-2/ https