<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1423459746958_2506996">You might look at the capabilities of systems like Netezza & Teradata. They have also adapted various tools around Postgres/Postgis to support parallelisation.</div><div id="yui_3_16_0_1_1423459746958_2507066"><br></div><div dir="ltr" id="yui_3_16_0_1_1423459746958_2507064">This comment on Netezza might be of interest:</div><div id="yui_3_16_0_1_1423459746958_2507114" dir="ltr"><a id="yui_3_16_0_1_1423459746958_2507115" href="http://geothought.blogspot.co.nz/2008/09/netezza-spatial.html">http://geothought.blogspot.co.nz/2008/09/netezza-spatial.html</a></div><div id="yui_3_16_0_1_1423459746958_2507150" dir="ltr"><br></div><div id="yui_3_16_0_1_1423459746958_2507163" dir="ltr">Cheers<br></div><div id="yui_3_16_0_1_1423459746958_2507165" dir="ltr"><br></div><div id="yui_3_16_0_1_1423459746958_2507152" dir="ltr">Brent Wood<br></div><div id="yui_3_16_0_1_1423459746958_2506994"><span></span></div><br> <div id="yui_3_16_0_1_1423459746958_2507000" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1423459746958_2506999" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1423459746958_2506998" dir="ltr"> <hr id="yui_3_16_0_1_1423459746958_2507168" size="1"> <font id="yui_3_16_0_1_1423459746958_2507002" face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> David Haynes II <dahaynes@umn.edu><br> <b><span style="font-weight: bold;">To:</span></b> PostGIS Development Discussion <postgis-devel@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, February 19, 2015 5:15 AM<br> <b id="yui_3_16_0_1_1423459746958_2507200"><span id="yui_3_16_0_1_1423459746958_2507199" style="font-weight: bold;">Subject:</span></b> Re: [postgis-devel] shp2pgsql<br> </font> </div> <div id="yui_3_16_0_1_1423459746958_2507004" class="y_msg_container"><br><div id="yiv8773816700"><div id="yui_3_16_0_1_1423459746958_2507007"><div id="yui_3_16_0_1_1423459746958_2507006" dir="ltr">Nothing published yet, but we are developing a working document.<div id="yui_3_16_0_1_1423459746958_2507009">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. </div></div><div id="yui_3_16_0_1_1423459746958_2507012" class="yiv8773816700gmail_extra"><br clear="none"><div class="qtdSeparateBR"><br><br></div><div class="yiv8773816700yqt6778019245" id="yiv8773816700yqtfd70546"><div id="yui_3_16_0_1_1423459746958_2507011" class="yiv8773816700gmail_quote">On Wed, Feb 18, 2015 at 9:48 AM, Rémi Cura <span dir="ltr"><<a rel="nofollow" shape="rect" ymailto="mailto:remi.cura@gmail.com" target="_blank" href="mailto:remi.cura@gmail.com">remi.cura@gmail.com</a>></span> wrote:<br clear="none"><blockquote id="yui_3_16_0_1_1423459746958_2507018" class="yiv8773816700gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div id="yui_3_16_0_1_1423459746958_2507017" dir="ltr"><div id="yui_3_16_0_1_1423459746958_2507016"><div id="yui_3_16_0_1_1423459746958_2507015"><div id="yui_3_16_0_1_1423459746958_2507014"><div id="yui_3_16_0_1_1423459746958_2507062">Hey,<br clear="none"></div>I find this research type very interesting.<br clear="none"></div>Do you have something published about your experiment and test of various cluster-postgres flavours?<br clear="none"><br clear="none"></div>About loading geometry into your cluster, you may prefer to change OGR, which can read a lot more formats<br clear="none"></div>(and is however slower than postgis shp2pgsql).<br clear="none"><div id="yui_3_16_0_1_1423459746958_2507023"><div id="yui_3_16_0_1_1423459746958_2507022"><br clear="none">Cheers,<br clear="none">Rémi-C<br clear="none"></div></div></div><div id="yui_3_16_0_1_1423459746958_2507025" class="yiv8773816700gmail_extra"><br clear="none"><div id="yui_3_16_0_1_1423459746958_2507029" class="yiv8773816700gmail_quote">2015-02-18 16:37 GMT+01:00 Stephen Woodbridge <span dir="ltr"><<a rel="nofollow" shape="rect" ymailto="mailto:woodbri@swoodbridge.com" target="_blank" href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>></span>:<br clear="none"><blockquote id="yui_3_16_0_1_1423459746958_2507028" class="yiv8773816700gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><span>On 2/18/2015 10:21 AM, David Haynes II wrote:<br clear="none">
</span><blockquote id="yui_3_16_0_1_1423459746958_2507027" class="yiv8773816700gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hello,<br clear="none">
<br clear="none">
I am working on a project that conducts high performance spatial<br clear="none">
analysis using postgresql and PostGIS. We have been searching for<br clear="none">
platforms that allow PostGIS to run in parallel. We have evaluated<br clear="none">
Postgres-xc and postgres-xl and determined that they do not meet our use<br clear="none">
case. Currently, I am evaluating CitusDB, but there seem to be some<br clear="none">
obstacles there as well. However, we are working on developing our own<br clear="none">
platform using Stado, which is dervied from GridSQL.<br clear="none">
<br clear="none">
We have had some initial results that look pretty promising and we are<br clear="none">
looking to modify the source code of the shp2pgsql to work with our new<br clear="none">
platform. If someone could provide the location of the code we would<br clear="none">
greatly appreciate it. Currently we are creating are geometries using<br clear="none">
the ST_GeomFromTxt function.<br clear="none">
</blockquote>
<br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="http://trac.osgeo.org/postgis/browser/trunk/loader">http://trac.osgeo.org/postgis/<u></u>browser/trunk/loader</a><br clear="none">
<br clear="none">
______________________________<u></u>_________________<br clear="none">
postgis-devel mailing list<br clear="none">
<a id="yui_3_16_0_1_1423459746958_2507032" rel="nofollow" shape="rect" ymailto="mailto:postgis-devel@lists.osgeo.org" target="_blank" href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>devel</a><br clear="none">
</blockquote></div><br clear="none"></div>
<br clear="none">_______________________________________________<br clear="none">
postgis-devel mailing list<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:postgis-devel@lists.osgeo.org" target="_blank" href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel</a><br clear="none"></blockquote></div></div><br clear="none"><br clear="all"><div><br clear="none"></div>-- <br clear="none"><div id="yui_3_16_0_1_1423459746958_2507036" class="yiv8773816700gmail_signature"><div id="yui_3_16_0_1_1423459746958_2507035" dir="ltr">David Haynes, Ph.D.<div>Research Associate Terra Populus</div><div>Minnesota Population Center</div><div><a rel="nofollow" shape="rect" target="_blank" href="http://www.terrapop.org/">www.terrapop.org</a></div></div></div><div class="yiv8773816700yqt6778019245" id="yiv8773816700yqtfd81903">
</div></div></div></div><br><div class="yqt6778019245" id="yqtfd24388">_______________________________________________<br clear="none">postgis-devel mailing list<br clear="none"><a shape="rect" ymailto="mailto:postgis-devel@lists.osgeo.org" href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a><br clear="none"><a shape="rect" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel</a></div><br><br></div> </div> </div> </div></body></html>