Scaling Postgres Episode 172 Per-Operation Explain | PG14 Contributions | Foreign Parallel Execution | Incremental View Maintenance
Get New Episodes Weekly!
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
YouTube Video
