[postgis-devel] shp2pgsql

[Brent Wood]

You might look at the capabilities of systems like Netezza & Teradata. They have also adapted various tools around Postgres/Postgis to support parallelisation.
This comment on Netezza might be of interest:http://geothought.blogspot.co.nz/2008/09/netezza-spatial.html
Cheers

Brent Wood

      From: David Haynes II <dahaynes at umn.edu>
 To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org> 
 Sent: Thursday, February 19, 2015 5:15 AM
 Subject: Re: [postgis-devel] shp2pgsql
   
Nothing published yet, but we are developing a working document.Mostly we are testing this viability of spatial datasets and if a platform supports complex spatial queries (i.e. vector raster overlay distributed across a series of nodes). In addition we plan to conducting testing on tile size and raster density in relation to these complex queries. 


On Wed, Feb 18, 2015 at 9:48 AM, Rémi Cura <remi.cura at gmail.com> wrote:

Hey,
I find this research type very interesting.
Do you have something published about your experiment and test of various cluster-postgres flavours?

About loading geometry into your cluster, you may prefer to change OGR, which can read a lot more formats
(and is however slower than postgis shp2pgsql).

Cheers,
Rémi-C

2015-02-18 16:37 GMT+01:00 Stephen Woodbridge <woodbri at swoodbridge.com>:

On 2/18/2015 10:21 AM, David Haynes II wrote:

Hello,

I am working on a project that conducts high performance spatial
analysis using postgresql and PostGIS. We have been searching for
platforms that allow PostGIS to run in parallel. We have evaluated
Postgres-xc and postgres-xl and determined that they do not meet our use
case. Currently, I am evaluating CitusDB, but there seem to be some
obstacles there as well. However, we are working on developing our own
platform using Stado, which is dervied from GridSQL.

We have had some initial results that look pretty promising and we are
looking to modify the source code of the shp2pgsql to work with our new
platform. If someone could provide the location of the code we would
greatly appreciate it. Currently we are creating are geometries using
the ST_GeomFromTxt function.


http://trac.osgeo.org/postgis/browser/trunk/loader

_______________________________________________
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 PopulusMinnesota Population Centerwww.terrapop.org
_______________________________________________
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/20150218/47866838/attachment.html>