This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2015

Planning Parallel and Distributed Queries

Date: 2015-10-29
Time: 10:30–11:20
Room: Palais I-III
Level: Advanced

In order to achieve vertical scalability across a variety of workloads, PostgreSQL will need the ability to use many CPU cores to process a single query; that is, parallel query. To achieve horizontal scalability, it will need the ability to distribute a single query across many nodes, with each node most likely accessed through PostgreSQL's Foreign Data Wrapper (FDW) machinery. Query planner enhancements are needed in each case, and the enhancements required for each of the two cases are surprisingly similar. In this talk, I'll discuss the similarities and differences between these two problems, as well as how they relate to a third much-needed PostgreSQL feature, declarative partitioning.

Speaker

Robert Haas