<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hm, with rasdaman ("raster data manager", <a class="moz-txt-link-abbreviated" href="http://www.rasdaman.org">www.rasdaman.org</a>) 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.<br>
Currently rasdaman is getting attached to GDAL, and a PostgreSQL link
for mixed queries is under development as well.<br>
<br>
-Peter<br>
<br>
<br>
<br>
On 07/19/2010 05:33 PM, Sebastian E. Ovide wrote:
<blockquote
cite="mid:AANLkTim-RA1l_7xo7t82bT9XkhHwj7L1gQn2KbpPxH8l@mail.gmail.com"
type="cite">Hi All,<br>
<br>
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....<br>
<br>
any successful case ?<br>
<br>
Thanks !<br>
<br>
<br>
<div class="gmail_quote">On Fri, Jul 16, 2010 at 1:13 AM, salas <span
dir="ltr"><<a moz-do-not-send="true" href="mailto:fsalas@geocuba.cu">fsalas@geocuba.cu</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff">
<div>Hello to all:<br>
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.<br>
I need to know the experience of somebody in a project of this span and
if PostGIS would present some limitation therewith.</div>
<div> </div>
<div>regards yuriesky </div>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a moz-do-not-send="true"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<br>
-- <br>
Sebastian E. Ovide<br>
<br>
<br>
<br>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="80">--
Dr. Peter Baumann
- Professor of Computer Science, Jacobs University Bremen
<a class="moz-txt-link-abbreviated" href="http://www.faculty.jacobs-university.de/pbaumann">www.faculty.jacobs-university.de/pbaumann</a>
mail: <a class="moz-txt-link-abbreviated" href="mailto:p.baumann@jacobs-university.de">p.baumann@jacobs-university.de</a>
tel: +49-421-200-3178, fax: +49-421-200-493178
- Executive Director, rasdaman GmbH Bremen (HRB 147737)
<a class="moz-txt-link-abbreviated" href="http://www.rasdaman.com">www.rasdaman.com</a>, mail: <a class="moz-txt-link-abbreviated" href="mailto:baumann@rasdaman.com">baumann@rasdaman.com</a>
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)
</pre>
</body>
</html>