[postgis-users] may have postgis store limits for a big project?

Peter Baumann p.baumann at jacobs-university.de
Mon Jul 19 08:51:26 PDT 2010

Hm, with rasdaman ("raster data manager", www.rasdaman.org) the French 
National Geographic Institute maintains a dozen-TB orthoimage since 
about 5 years now with quite speedy access (a few 100ms), including 
random subsetting. Also, further on-the-fly data massaging (band 
extraction, recombination, classification, ...) is possible in SQL style.
Currently rasdaman is getting attached to GDAL, and a PostgreSQL link 
for mixed queries is under development as well.


On 07/19/2010 05:33 PM, Sebastian E. Ovide wrote:
> Hi All,
> I am interesting too... I am considering PostGIS+WKTRaster instead of 
> Oracle GeoRaster... but for that can happen, Postgresql must be able 
> of managing some simple tables of 30+M (Millions) rows plus a lot of 
> Rasters of 16GB each... (16GB not compress data... so are huge images 
> !). Each query (simple look up) must response in a fraction of second....
> any successful case ?
> Thanks !
> On Fri, Jul 16, 2010 at 1:13 AM, salas <fsalas at geocuba.cu 
> <mailto:fsalas at geocuba.cu>> wrote:
>     Hello to all:
>     I am working in a project where they are managed more than 20
>     geoespatials thematics. Each thematic one has a considerable
>     volume of since information it is of the whole country (I am
>     speaking of a lot more than a million of records). In the project
>     we need to make (mostly) intersection consultations keeping in
>     mind literal attributes.
>     I need to know the experience of somebody in a project of this
>     span and if PostGIS would present some limitation therewith.
>     regards yuriesky
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
> -- 
> Sebastian E. Ovide

Dr. Peter Baumann
  - Professor of Computer Science, Jacobs University Bremen
    mail: p.baumann at jacobs-university.de
    tel: +49-421-200-3178, fax: +49-421-200-493178
  - Executive Director, rasdaman GmbH Bremen (HRB 147737)
    www.rasdaman.com, mail: baumann at rasdaman.com
    tel: 0800-rasdaman, fax: 0800-rasdafax, mobile: +49-173-5837882
"Si forte in alienas manus oberraverit hec peregrina epistola incertis ventis dimissa, sed Deo commendata, precamur ut ei reddatur cui soli destinata, nec preripiat quisquam non sibi parata." (mail disclaimer, AD 10xx)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100719/d63cf5ec/attachment.html>

More information about the postgis-users mailing list