For analytical loads the following is going to be great: While PostgreSQL 9.6 offers parallel query, this feature has been significantly improved in Postg

For analytical loads the following is going to be great: While PostgreSQL 9.6 offers parallel query, this feature has been significantly improved in PostgreSQL 10, with new features like Parallel Bitmap Heap Scan, Parallel Index Scan, and others. Speedups of 2-4x are common with parallel query, and these enhancements should allow those speedups to happen for a wider variety of queries.