PostGIS 2.3 parallel performance 2 times faster on PostgreSQL 9.6 on a real live example

This blog post will show an example for the parallel query processing capabilities from PostGIS 2.3 running on PostgeSQL 9.6. It is based on the project Lebensriskoexplorer. The data that I am using are exported from my google location history from 2015. The region data is taken from the Bundesamt für Kartographie und Geodäsie. So overall[…]