We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Parallel Query Has Arrived!

Formal Metadata

Title
Parallel Query Has Arrived!
Title of Series
Number of Parts
34
Author
License
CC Attribution 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
Capabilities expected to be part of PostgreSQL 9.6 will substantially improve the performance of queries that touch large volumes of data, such as reporting queries on databases used primarily for OLTP. I'll discuss those improvements with examples and benchmark results. In addition, I'll discuss the cases where the current implementation fails to speed things up as much as one might hope, either because the optimal plan is not generated or because the plan fails to run as fast in parallel as might be hoped, and explain how we might improve things in the future. Finally, I'll discuss the pluggable nature of the parallelism infrastructure and explain how, first, it can be used for purposes other than running queries, and, second, if part of it doesn't work well in a particular case, a replacement part can be substituted in for that particular purpose without much impact on the surrounding code.