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

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.

Content Discussed

• Calculating per-operation times in EXPLAIN ANALYZE
• Some Interesting statistics about PG-14 contributions
• Parallel execution of postgres_fdw scan’s in PG-14 (Important step forward for horizontal scaling)
• Implementing Incremental View Maintenance for PostgreSQL (Part III)
• Updates of PostgreSQL Observability diagram.
• Ora2PG now supports oracle_fdw to increase the data migration speed
• PostGIS 3.1.3
• PostGIS setup with Ubuntu 20.04.2
• How to Deploy pgAdmin in Kubernetes
• Stefan Keller
• Rubber Duck Dev Show Episode 2 | Software Development Technical Project Management