[postgis-devel] any spatial databases for high performance geo-computing

[Imre Samu]

maybe   http://www.postgres-xl.org/ ??   (=  Scalable Open Source
PostgreSQL-based Database Cluster -  includes Massively Parallel Processing
(MPP) capability  )

http://www.postgres-xl.org/faq/
"Q. Is PostGIS supported?
Yes, PostGIS can be added to Postgres-XL. It has been tested with PostGIS
2.0
Q. How does Postgres-XL relate to StormDB?
Postgres-XL is the core of TransLattice Storm (StormDB) rebranded and open
sourced.
..
Q. Are Business Intelligence applications supported?
Yes, Postgres-XL includes Massively Parallel Processing (MPP) capability
with sophisticated query planning and inter-node communication that allows
it to fulfill query requests over large data sets quickly. Postgres-XL is
well suited for Data Warehousing and Data Marts. In Postgres-XL queries are
parallelized and the data node nodes communicate with one another directly.
"

but

"Q. Are geo-distributed database clusters supported?
No, geo-distribution is not natively supported. A Postgres-XL-based
solution will depend on your particular requirements, and you should
probably engage with a company that is experienced with Postgres-XL."


Imre

.


2014-05-20 0:04 GMT+02:00 Zhang, Shuai <shuai at illinois.edu>:

> Hi All,
>
> sorry for asking, but what do you think is a good choice of spatial
> database for high performance geo-computing?
>
> In some high performance computing scenarios, data size tends to be huge,
> and a bunch of computer clusters work together with high throughput and
> tense computation. sometimes we use parallel filesystems like lustre, gfs,
> hdfs to handle specific problems but what if a spatial database?
>
> I explored some of postgresql cluster solutions, such as streaming
> replication, pgpool, slony and so on. I think most of them are designed for
> failover, and they might not be able to stand up with the huge data size
> and high performance demands. the case is quite alike in oracle and db2
> spatial, i think.
>
> so any suggestions for projects aiming to build a distributed and parallel
> spatial database running on a cluster?
>
> Thanks,
> shuai
> _______________________________________________
> 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/20140520/0233731b/attachment.html>