Per-Operation Explain, PG14 Contributions, Foreign Parallel Execution, Incremental View Maintenance | Scaling Postgres 172
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/
Create your
podcast in
minutes
It is Free