Room: Palais I-III
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.