I promised an article on parallel queries in PostGIS from Paul Ramsey, so here it is. I’m particularly excited about the performance improvements from the by-default parallelisation of spatial queries in PostGIS 3.0.0 when coupled with PostgreSQL 12. I can’t wait!
Parallel PostGIS and PgSQL 12 (2)
In my last post I demonstrated that PostgreSQL 12 with PostGIS 3 will provide, for the first time, automagical parallelization of many common spatial queries. This is huge news, as it opens up the possibility of extracting more performance from modern server hardware. Commenters on the post immedia…
Paul Ramsey