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://www.enterprisedb.com/blog/how-deploy-pgadmin-kubernetes

https://postgresql.life/post/stefan_keller/

https://www.rubberduckdevshow.com/episodes/2-software-development-technical-project-management/