Where next for parallel query execution?
October 20–23
Level: Intermediate
PostgreSQL added single-node parallel query execution in a series of leaps and bounds a few years ago, but it is far from finished. This talk is a reflection on design choices made, path dependencies that influenced those choices, where they sit in the design space, and a selection of major opportunities that remain open for future development.
- How does PostgreSQL plan and execute queries that use multiple CPUs?
- Missing, incomplete, sub-optimal and unorthodox features
- How do other systems do it, and what can we learn from them?
Topics touched on include planning strategies, resource management, write queries, efficiency and overall architecture.
