PostgreSQL 10 Administration Cookbook - Fourth Edition

There's more…

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