[postgis-devel] Sharding Rasters in Postgis

[Paul Ramsey]

If you’re just doing queries that don’t take advantage of spatial correlation at all, using any hashkey on the contents as the sharding key should work just great. Then you can use pl/proxy to run roll-ups against spatial polygons, etc, easily and know you won’t end up with hot nodes.

P

-- 
Paul Ramsey
http://cleverelephant.ca
http://postgis.net

On September 23, 2014 at 2:11:18 PM, David Haynes II (dahaynes at umn.edu) wrote:

Yes, we are going to use the more finished product Postgres-xl, but even that is not production ready. 
So I would think the most logical solution is to generate the process ourselves.

Mostly wondering how to distribute the tables to various locations, once I do the difficulty part of aligning tiles to exist with a defined coordinate space.

On Mon, Sep 22, 2014 at 11:12 AM, Rémi Cura <remi.cura at gmail.com> wrote:
Do you mean somethiong like postgres-xc :http://postgresxc.wikia.com/wiki/Postgres-XC_Wiki

Cheers,
Rémi-C

2014-09-22 17:04 GMT+02:00 David Haynes II <dahaynes at umn.edu>:
Hello,

I was wondering if there any helpful examples for distributing rasters tables in postgis. Are there other items that I need to consider? Will the PostGIS functions need to be re-written if we want to parallelize the processing, using something like pg_proxy? 

I came an example using a different software package, (slide 16)
http://spark-summit.org/wp-content/uploads/2014/07/Geotrellis-Adding-Geospatial-Capabilities-to-Spark-Ameet-Kini-Rob-Emanuele.pdf
I would prefer to stay within postgresql community.

--
David Haynes, Ph.D.
Research Associate Terra Populous
Minnesota Population Center

_______________________________________________
postgis-devel mailing list
postgis-devel at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel


_______________________________________________
postgis-devel mailing list
postgis-devel at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel



--
David Haynes, Ph.D.
Research Associate Terra Populous
Minnesota Population Center
_______________________________________________  
postgis-devel mailing list  
postgis-devel at lists.osgeo.org  
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20140923/d66446d8/attachment.html>