Conference Schedule - FOSDEM PGDay 2019

Parallelism in PostgreSQL 11

Date: 2019-02-01
Time: 11:30 - 12:20
Room: Hotel

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 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.

Speaker

Thomas Munro