May 2018
Intermediate to advanced
576 pages
30h 25m
English
PostgreSQL 9.6 includes the basic parallel query feature. In this release, it works with Seq Scans, aggregation, and to a certain extent with joins. For many cases this is a very useful addition. PostgreSQL 10 adds plan improvements that allows parallel query to work with btree index scans, bitmap heap scans, merge joins and non-correlated subqueries. Also, in PostgreSQL 10 you can now get parallel query plans from SQL inside procedural language functions.
If you have an immediate requirement for higher levels of scalability or very large databases then you'll want to look at the Postgres-XL project. Postgres-XL is an open source project using The PostgreSQL License that has modified PostgreSQL to provide multi-node parallel ...