[postgis-users] parallel spatial calculation

Regina Obe lr at pcorp.us
Thu Aug 23 04:39:12 PDT 2018

Not sure what you mean by parallel spatial calculations.


In theory most functions in PostGIS can run in parallel assuming they are not restricted by the plan with the exception of most aggregates ( the MVT and ST_MemUnion (which no one uses) and I think possible ST_Extent (have to double check that) are the only aggregates that support parallel.  Even those are allowed in subplan nodes.  Most functions in PostGIS are marked as safe for parallel so should be able to run in parallel fine.


But PostgreSQL itself has many restrictions on parallelism – e.g. the cost, the number of tuples before it considers parallel, update/insert statements can't use parallel.  These restrictions are slowly being lifted with each new version e.g. 11 supports more kinds of plan nodes and allows CREATE TABLE AS to run in parallel.





From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of David Haynes
Sent: Wednesday, August 22, 2018 4:10 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] parallel spatial calculation




I have a few questions regarding parallel spatial calculations.


Since PostgreSQL 10 is allowing for multiple workers is there any work on allowing parallel spatial calculations? Is there anyone potentially looking at VoltDB as a potential place for testing any parallel spatial calculations. VoltDB's spatial capabilities are completely undeveloped but it might be a place to start.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180823/74c527ae/attachment.html>

More information about the postgis-users mailing list