[postgis-users] parallel spatial calculation

[David Haynes]

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.
>
> Regards.
>
> Le 22/08/2018 à 22:09, David Haynes a écrit :
>
> Hello,
>
> 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
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180824/f5c757cb/attachment.html>