[postgis-users] may have postgis store limits for a big project?
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>
> 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...
More information about the postgis-users