The PostGIS development team is pleased to announce the release of PostGIS 2.3.0.
This is the first version to utilize the parallel support functionality introduced in PostgreSQL 9.6. As such, if you are using PostgreSQL 9.6, we strongly encourage you to use this version.
Parallel support will make many queries using PostGIS relationship operators and functions faster.
In order to take advantage of parallel query support, make sure to set
max_parallel_workers_per_gather to something greater than 0
as noted in
max_parallel_workers_per_gather PostgreSQL runtime configs
Best served with [PostgreSQL 9.6+] which is due out this week and pgRouting 2.3.0 which also just got released.
Packages from maintainers will be out in the coming days and weeks.