Session
BackParallelism in PostgreSQL 11
Date: 2018-09-06
Time: 18:30 - 19:20
Room: Cyril Magnin
Level: Intermediate
Feedback: Leave feedback
An overview of how parallel query execution works, with a look at some of the gory details that let you use multiple CPU cores for a single query in recent PostgreSQL releases. Topics covered include:
- Industry and academic context
- PostgreSQL context and infrastructure
- How parallel queries are planned
- How parallel queries are executed
- Practical examples, results and tuning
- Problems to solve, opportunities for future work and related projects
The talk is aimed at application developers, DBAs and new PostgreSQL hackers who want to understand our model of parallelism, what kinds of problems it can help with and what's going on under the hood.