[postgis-users] parallel spatial calculation
haynesd2 at gmail.com
Fri Aug 24 12:13:42 PDT 2018
Thanks for the input.
My understanding of the parallel capabilities of PostgreSQL is somewhat
limited, but I believe the workers are done at the query level, without
partitioning. This likely result in different query performances compared
to a dataset that is partitioned. Also, the partitions scheme used on
spatial dataset can have a great effect on the performance of the spatial
query that you run. It is something I'm very interested in and I didn't
know if anyone in this group was working in this area.
On Thu, Aug 23, 2018 at 7:15 AM Cedric Duprez <Cedric.Duprez at ign.fr> wrote:
> Hi David,
> I remember two good posts on Paul Ramsey’s blog explaining query
> parallelism and PostGIS :
> - http://blog.cleverelephant.ca/2017/10/parallel-postgis-2.html
> - http://blog.cleverelephant.ca/2017/11/parallel-postgis-2A.html
> I hope it helps you.
> Le 22/08/2018 à 22:09, David Haynes a écrit :
> 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.
> postgis-users mailing listpostgis-users at lists.osgeo.orghttps://lists.osgeo.org/mailman/listinfo/postgis-users
> postgis-users mailing list
> postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users