Schedule - PgDU 2018

Parallelism in PostgreSQL 11

Date: 2018-12-07
Time: 13:30–14:15
Room: Conference Room
Level: Intermediate

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:

  • Some industry and academic context
  • PostgreSQL context and infrastructure
  • How parallel queries are planned
  • How parallel queries are executed
  • Practical examples, results and tuning
  • Opportunities for future work

The talk is aimed at application developers, DBAs anyone who wants to understand our model of parallelism, what kinds of problems it can help with and what's going on under the hood.

Speaker

Thomas Munro